| SQL Id | SQL Text |
|---|
| 0074pdmwb7fmv | BEGIN WSH_SHIP_CONFIRM_ACTIONS.interface_ALL_wrp(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8); END; |
| 03r0vwczazc4d |
declare l_return_status VARCHAR2 ( 2000 ) ; l_msg_count NUMBER ; l_msg_data VARCHAR2 ( 2000 ) ; l_instrument_assignment_id NUMBER ; l_response_rec IBY_FNDCPT_COMMON_PUB . RESULT_REC_TYPE ; l_payment_trxn_extension_id NUMBER ; l_payer_rec IBY_FNDCPT_COMMON_PUB . PAYERCONTEXT_REC_TYPE ; l_trxn_attribs_rec IBY_FNDCPT_TRXN_PUB . TRXNEXTENSION_REC_TYPE ; l_cust_account_id NUMBER ; l_cust_site_use_id NUMBER ; l_party_id NUMBER ; l_org_id NUMBER ; l_org_type VARCHAR2 ( 30 ) ; l_payment_function VARCHAR2 ( 30 ) ; l_payment_channel VARCHAR2 ( 30 ) ; l_instrument_type VARCHAR2 ( 30 ) ; cursor lines_rec_cur is select distinct l . customer_trx_id , l . trx_number , l . paying_customer_id , l . paying_site_use_id , l . orig_system_bill_customer_id , l . orig_system_bill_address_id , l . org_id , l . receipt_method_id , l . currency_code , l . trx_date , rm . payment_channel_code , pc . instrument_type , su . site_use_id bill_to_site_use_id from ra_interface_lines_gt l , ar_receipt_methods rm , ar_receipt_classes rc , iby_fndcpt_pmt_chnnls_b pc , hz_cust_site_uses su where l . request_id = fnd_global . conc_request_id and l . receipt_method_id is not null and l . customer_trx_id is not null and l . payment_trxn_extension_id is null and nvl ( l . interface_status , '~' ) != 'P' and rm . receipt_method_id = l . receipt_method_id and rm . receipt_class_id = rc . receipt_class_id and rc . creation_method_code in ( 'AUTOMATIC' , 'BR' ) and rm . payment_channel_code = pc . paym
ent_channel_code and su . site_use_code = 'BILL_TO' and su . cust_acct_site_id = l . orig_system_bill_address_id ; BEGIN arp_standard . debug ( 'Default Payment Transaction Extension ID()+' ) ; FOR line_rec IN lines_rec_cur LOOP l_payment_channel := line_rec . payment_channel_code ; l_instrument_type := line_rec . instrument_type ; l_instrument_assignment_id := NULL ; l_payment_trxn_extension_id := NULL ; IF l_instrument_type = 'CREDITCARD' THEN Select substrb ( max ( decode ( acct_site_use_id , NULL , '1' || to_char ( instr_assignment_id ) , '2' || to_char ( instr_assignment_id ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'CREDITCARD' and order_of_preference = 1 and cust_account_id = line_rec . paying_customer_id and line_rec . paying_site_use_id = nvl ( acct_site_use_id , line_rec . paying_site_use_id ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; IF l_instrument_assignment_id IS NULL THEN Select substrb ( max ( decode ( acct_site_use_id , NULL , '1' || to_char ( instr_assignment_id ) , '2' || to_char ( instr_assignment_id ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'CREDITCARD' and order_of_preference = 1 and cust_account_id = line_rec . orig_system_bill_customer_id and line_rec . bill_to_site_use_id = nvl ( acct_site_use_id , line_rec . bill_to_site_
use_id ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; END IF ; ELSIF l_instrument_type = 'BANKACCOUNT' THEN Select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( instr_assignment_id ) , '3' || to_char ( instr_assignment_id ) ) , decode ( currency_code , NULL , '2' || to_char ( instr_assignment_id ) , '1' || to_char ( instr_assignment_id ) ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . paying_customer_id and line_rec . paying_site_use_id = nvl ( acct_site_use_id , line_rec . paying_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and order_of_preference = ( select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( order_of_preference ) , '3' || to_char ( order_of_preference ) ) , decode ( currency_code , NULL , '2' || to_char ( order_of_preference ) , '1' || to_char ( order_of_preference ) ) ) ) , 2 ) from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . paying_customer_id and line_rec . paying_site_use_id = nvl ( acct_site_use_id , line_rec . paying_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and line_rec . tr
x_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; IF l_instrument_assignment_id IS NULL THEN Select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( instr_assignment_id ) , '3' || to_char ( instr_assignment_id ) ) , decode ( currency_code , NULL , '2' || to_char ( instr_assignment_id ) , '1' || to_char ( instr_assignment_id ) ) ) ) , 2 ) into l_instrument_assignment_id from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . orig_system_bill_customer_id and line_rec . bill_to_site_use_id = nvl ( acct_site_use_id , line_rec . bill_to_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and order_of_preference = ( select substrb ( min ( decode ( acct_site_use_id , NULL , decode ( currency_code , NULL , '4' || to_char ( order_of_preference ) , '3' || to_char ( order_of_preference ) ) , decode ( currency_code , NULL , '2' || to_char ( order_of_preference ) , '1' || to_char ( order_of_preference ) ) ) ) , 2 ) from IBY_FNDCPT_payer_assgn_instr_v where instrument_type = 'BANKACCOUNT' and cust_account_id = line_rec . orig_system_bill_customer_id and line_rec . bill_to_site_use_id = nvl ( acct_site_use_id , li
ne_rec . bill_to_site_use_id ) and line_rec . currency_code = nvl ( currency_code , line_rec . currency_code ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ) and line_rec . trx_date between NVL ( assignment_start_date , line_rec . trx_date ) and NVL ( assignment_end_date , line_rec . trx_date ) ; END IF ; END IF ; arp_standard . debug ( 'l_instrument_assignment_id :- ' || l_instrument_assignment_id ) ; IF l_instrument_assignment_id IS NOT NULL THEN select party_id , cust_account_id , acct_site_use_id , org_id , org_type , payment_function into l_party_id , l_cust_account_id , l_cust_site_use_id , l_org_id , l_org_type , l_payment_function from IBY_FNDCPT_payer_assgn_instr_v where instr_assignment_id = l_instrument_assignment_id and rownum < 2 ; l_payer_rec . payment_function := l_payment_function ; l_payer_rec . party_id := l_party_id ; l_payer_rec . cust_account_id := l_cust_account_id ; l_payer_rec . account_site_id := l_cust_site_use_id ; l_payer_rec . org_id := l_org_id ; l_payer_rec . org_type := l_org_type ; l_trxn_attribs_rec . originating_application_id := arp_standard . application_id ; l_trxn_attribs_rec . order_id := line_rec . customer_trx_id ; l_trxn_attribs_rec . trxn_ref_number1 := 'TRANSACTION' ; l_trxn_attribs_rec . trxn_ref_number2 := line_rec . customer_trx_id ; IBY_FNDCPT_TRXN_PUB . CREATE_TRANSACTION_EXTENSION ( p_api_version => 1.0 , p_init_
msg_list => FND_API . G_TRUE , p_commit => FND_API . G_FALSE , x_return_status => l_return_status , x_msg_count => l_msg_count , x_msg_data => l_msg_data , p_payer => l_payer_rec , p_payer_equivalency => IBY_FNDCPT_COMMON_PUB . G_PAYER_EQUIV_UPWARD , p_pmt_channel => l_payment_channel , p_instr_assignment => l_instrument_assignment_id , p_trxn_attribs => l_trxn_attribs_rec , x_entity_id => l_payment_trxn_extension_id , x_response => l_response_rec ) ; IF l_return_status = FND_API . G_RET_STS_SUCCESS THEN arp_standard . debug ( 'l_payment_trxn_extension_id :- ' || l_payment_trxn_extension_id ) ; update ra_interface_lines_gt set payment_trxn_extension_id = l_payment_trxn_extension_id where customer_trx_id = line_rec . customer_trx_id and request_id = fnd_global . conc_request_id and receipt_method_id is not null ; ELSE arp_standard . debug ( 'Processing customer_trx_id :- ' || line_rec . customer_trx_id ) ; arp_standard . debug ( 'result_code :- ' || l_response_rec . result_code ) ; arp_standard . debug ( 'result_category :- ' || l_response_rec . result_category ) ; arp_standard . debug ( 'result_message :- ' || l_response_rec . result_message ) ; arp_standard . debug ( 'l_return_status :- ' || l_return_status ) ; arp_standard . debug ( 'l_msg_count :- ' || l_msg_count ) ; arp_standard . debug ( 'l_msg_data :- ' || l_msg_data ) ; END IF ; END IF ; END LOOP ; arp_standard . debug ( 'Default Payment Transaction Extension ID()-' ) ; E
XCEPTION WHEN OTHERS THEN arp_standard . debug ( 'Error in Default Payment Transaction Extension ID' ) ; arp_standard . debug ( '[' || SQLERRM ( SQLCODE ) || ']' ) ; RAISE ; END ; |
| 0758ng3cbw07m | SELECT STOP_ID FROM WSH_TRIP_STOPS WHERE BATCH_ID = :B1 FOR UPDATE NOWAIT |
| 0fks7wk7hfq2n | begin arp_process_payinfo . default_payment_attributes ; EXCEPTION WHEN OTHERS THEN arp_standard . debug ( 'Error in arp_process_payinfo.' || 'default_payment_attributes()' ) ; arp_standard . debug ( '[' || SQLERRM ( SQLCODE ) || ']' ) ; RAISE ; END ; |
| 0mdnts20d60yr | declare
v_ret number := 0;
begin
if (INV_TABLE_LOCK_PVT.lock_onhand_records(:1, :2, :3, :4, :5, :6, :7, :8))
then
v_ret := 1;
end if;
:9 := v_ret;
end;
|
| 0wabkkyua3y3v | SELECT ITEM_KEY FROM WF_ITEMS WHERE ITEM_TYPE = :B2 AND ITEM_KEY = :B1 FOR UPDATE |
| 0z318y6g3uagc | declare l_retstat varchar2 ( 3 ) ; l_msg_data varchar2 ( 244 ) ; l_msg_cnt number ; l_trx_cnt number ; BEGIN :retval := INV_TXN_MANAGER_PUB . process_Transactions ( p_api_version => 1.0 , p_commit => fnd_api . g_true , x_return_status => l_retstat , x_msg_count => l_msg_cnt , x_msg_data => l_msg_data , x_trans_count => l_trx_cnt , p_table => 1 , p_header_id => :header_id ) ; END ; |
| 1c0b7sas42w2z | SELECT NVL(ITEM_COST, 0), COST_UPDATE_ID FROM CST_ITEM_COSTS WHERE INVENTORY_ITEM_ID = :1 AND ORGANIZATION_ID = :2 AND COST_TYPE_ID = :3 |
| 1p2p9fdwaujpv | update MTL_TRANSACTIONS_INTERFACE MTI set TRANSACTION_HEADER_ID=:b0, LAST_UPDATE_DATE=SYSDATE, LAST_UPDATED_BY=:b1, LAST_UPDATE_LOGIN=:b2, PROGRAM_APPLICATION_ID=:b3, PROGRAM_ID=:b4, REQUEST_ID=:b5, PROGRAM_UPDATE_DATE=SYSDATE, LOCK_FLAG=1, ERROR_CODE=null , ERROR_EXPLANATION=null where (((((PROCESS_FLAG=1 and NVL(LOCK_FLAG, 2)=2) and TRANSACTION_MODE=3) and ROWNUM<=:b6) and exists (select 'X' from MTL_TRANSACTION_TYPES MTT where (MTT.TRANSACTION_TYPE_ID=MTI.TRANSACTION_TYPE_ID and MTT.TRANSACTION_SOURCE_TYPE_ID in (2, 8, 16)))) and exists (select 1 from ORG_ORGANIZATION_DEFINITIONS OOD where (OOD.ORGANIZATION_ID=MTI.ORGANIZATION_ID and NVL(OOD.DISABLE_DATE, (SYSDATE+1))>SYSDATE))) |
| 1v818hwxjxy58 | select FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.FLEX_VALUE, FND_FLEX_VALUES_VL.DESCRIPTION, FND_FLEX_VALUES_VL.ENABLED_FLAG, to_char(FND_FLEX_VALUES_VL.START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(FND_FLEX_VALUES_VL.END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), FND_FLEX_VALUES_VL.SUMMARY_FLAG, FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES from FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL where (( FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :FND_BIND1) AND (
((1=1)
AND /* GL_COA_BS_TAG */
(GL_AFF_AWC_API_PKG.gl_valid_flex_values(:FND_BIND2, FND_FLEX_VALUES_VL.Flex_Value) = 'Y')
)
)) and FND_FLEX_VALUES_VL.FLEX_VALUE = :FND_BIND3 |
| 1wnq9qthbb54q | BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5); END; |
| 2skwhauh2cwky | select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.user# |
| 33838u0xy9fk9 |
INSERT INTO MTL_MATERIAL_TRANSACTIONS (
TRANSACTION_ID,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
LAST_UPDATE_LOGIN,
REQUEST_ID,
PROGRAM_ID,
PROGRAM_APPLICATION_ID,
INVENTORY_ITEM_ID,
ORGANIZATION_ID,
SUBINVENTORY_CODE,
LOCATOR_ID,
REVISION,
TRANSACTION_TYPE_ID,
TRANSACTION_ACTION_ID,
TRANSACTION_SOURCE_TYPE_ID,
TRANSACTION_SOURCE_ID,
TRANSACTION_SOURCE_NAME,
TRANSACTION_QUANTITY,
TRANSACTION_UOM,
PRIMARY_QUANTITY,
TRANSACTION_DATE,
TRANSACTION_COST,
ACTUAL_COST,
PRIOR_COST,
NEW_COST,
QUANTITY_ADJUSTED,
VARIANCE_AMOUNT,
TRANSFER_COST,
TRANSPORTATION_COST,
TRANSFER_TRANSACTION_ID,
TRANSFER_ORGANIZATION_ID,
TRANSFER_SUBINVENTORY,
TRANSFER_LOCATOR_ID ,
ACCT_PERIOD_ID,
TRANSACTION_REFERENCE,
REASON_ID,
REPETITIVE_LINE_ID,
DEPARTMENT_ID,
OPERATION_SEQ_NUM,
SHIPMENT_NUMBER,
FREIGHT_CODE,
WAYBILL_AIRBILL,
TRX_SOURCE_LINE_ID,
MOVE_ORDER_LINE_ID ,
INVOICED_FLAG ,
DISTRIBUTION_ACCOUNT_ID ,
ENCUMBRANCE_ACCOUNT ,
ENCUMBRANCE_AMOUNT ,
COST_U
PDATE_ID ,
PROJECT_ID ,
TASK_ID ,
TO_PROJECT_ID ,
TO_TASK_ID ,
LPN_ID , TRANSFER_LPN_ID,
CONTENT_LPN_ID ,
PUT_AWAY_STRATEGY_ID ,
PUT_AWAY_RULE_ID ,
PICK_STRATEGY_ID ,
PICK_RULE_ID ,
CREATED_BY ,
COST_GROUP_ID ,
TRANSFER_COST_GROUP_ID ,
TRANSACTION_SET_ID ,
PM_COST_COLLECTED ,
COST_CATEGORY_ID ,
ORGANIZATION_TYPE ,
TRANSFER_ORGANIZATION_TYPE ,
OWNING_ORGANIZATION_ID ,
OWNING_TP_TYPE ,
PLANNING_ORGANIZATION_ID ,
PLANNING_TP_TYPE ,
XFR_OWNING_ORGANIZATION_ID ,
TRANSFER_OWNING_TP_TYPE ,
XFR_PLANNING_ORGANIZATION_ID ,
TRANSFER_PLANNING_TP_TYPE ,
SECONDARY_TRANSACTION_QUANTITY ,
SECONDARY_UOM_CODE,
PICK_SLIP_NUMBER,
PICKING_LINE_ID,
VENDOR_LOT_NUMBER,
SOURCE_CODE,
SOURCE_LINE_ID,
MOVE_TRANSACTION_ID,
RCV_TRANSACTION_ID,
COMPLETION_TRANSACTION_ID,
CURRENCY_CODE,
CURRENCY_CONVERSION_RATE,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_TYPE,
MATERIAL_ACCOUNT,
MATERIAL_OVERHEAD_ACCOUNT,
RESOURCE_ACCOUNT,
OUTSIDE_PROCESSING_ACCOUNT,
OVERHEAD_ACCOUNT,
MOVEMENT_ID,
SOUR
CE_PROJECT_ID,
SOURCE_TASK_ID,
PA_EXPENDITURE_ORG_ID,
EXPENDITURE_TYPE,
TRANSFER_PERCENTAGE,
ORG_COST_GROUP_ID,
COST_TYPE_ID,
VALUE_CHANGE,
PERCENTAGE_CHANGE,
EMPLOYEE_CODE,
MASTER_SCHEDULE_UPDATE_CODE,
TRX_SOURCE_DELIVERY_ID,
RECEIVING_DOCUMENT,
TRANSPORTATION_DIST_ACCOUNT,
NUMBER_OF_CONTAINERS,
RMA_LINE_ID,
CYCLE_COUNT_ID,
PHYSICAL_ADJUSTMENT_ID,
FLOW_SCHEDULE,
FINAL_COMPLETION_FLAG,
QA_COLLECTION_ID,
OVERCOMPLETION_TRANSACTION_QTY,
OVERCOMPLETION_PRIMARY_QTY,
OVERCOMPLETION_TRANSACTION_ID,
COMMON_BOM_SEQ_ID,
COMMON_ROUTING_SEQ_ID,
MVT_STAT_STATUS,
PICK_SLIP_DATE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
SHIP_TO_LOCATION_ID,
TRANSACTION_MODE,
TRANSACTION_BATCH_ID,
TRANSACTION_BATCH_SEQ,
FOB_POINT,
INTRANSIT_ACCOUNT,
TRX_FLOW_HEADER_ID,
LOGICAL_TRX_TYPE_CODE,
ORIGINAL_TRANSACTION_TEMP_ID,
SHORTAGE_PROCESS_CODE,
TRANSFER_PRICE,
COSTED_FLAG,
OPM_COSTED_FLAG )
VALUES(:1, SYSDATE, :2, SYSDATE, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, ROUND(:17, 5), :18, ROUND(:19, 5), nvl(:20, sysdate), :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, 'N', :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, ROUND(:75, 5), :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, 'NEW', :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, Decode(:149, 'D', 'N', NULL), DECODE(:150, 'O', 'N', NULL)) |
| 34bx0h6k0q8a1 |
SELECT TAX_REGIME_CODE, TAX, STATUS_RESULT, RATE_RESULT, CONDITION_SET_ID, EXCEPTION_SET_ID, RESULT_ID, QUERY_NUM FROM (SELECT /*+ leading(PR) use_nl(RL) */ RL.TAX_REGIME_CODE, RL.TAX, PR.STATUS_RESULT, PR.RATE_RESULT, PR.CONDITION_SET_ID, PR.EXCEPTION_SET_ID, PR.RESULT_ID, 1 QUERY_NUM, TAX.COMPOUNDING_PRECEDENCE FROM ZX_PROCESS_RESULTS PR, ZX_SCO_RULES_B_V RL, ZX_SCO_TAXES_B_V TAX WHERE (PR.CONDITION_GROUP_CODE = :B2 OR PR.CONDITION_GROUP_CODE LIKE :B2 ||'~'||'%') AND RL.EFFECTIVE_FROM <= :B1 AND (RL.EFFECTIVE_TO >= :B1 OR RL.EFFECTIVE_TO IS NULL ) AND PR.ENABLED_FLAG = 'Y' AND RL.TAX_RULE_ID = PR.TAX_RULE_ID AND RL.SERVICE_TYPE_CODE = 'DET_DIRECT_RATE' AND TAX.TAX_REGIME_CODE=RL.TAX_REGIME_CODE AND TAX.TAX=RL.TAX AND EXISTS (SELECT /*+ no_unnest */ 1 FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_REGIME_CODE = RL.TAX_REGIME_CODE AND RT.TAX = RL.TAX AND RT.TAX_STATUS_CODE = PR.STATUS_RESULT AND RT.TAX_RATE_CODE = PR.RATE_RESULT AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFECTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B3 OR RT.TAX_CLASS IS NULL)) UNION ALL SELECT /*+ leading(RT.a) use_nl(RT.sd) */ DISTINCT RT.TAX_REGIME_CODE, RT.TAX, RT.TAX_STATUS_CODE, RT.TAX_RATE_CODE, NULL CONDITION_SET_ID, NULL EXCEPTION_SET_ID, NULL RESULT_ID, 2 QUERY_NUM, -1 COMPOUNDING_PRECEDENCE FROM ZX_SCO_RATES_B_V RT WHERE RT.TAX_RATE_CODE = :B4 AND RT.RATE_TYPE_CODE <> 'RECOVERY' AND RT.EFFECTIVE_FROM <= :B1 AND (RT.EFFE
CTIVE_TO >= :B1 OR RT.EFFECTIVE_TO IS NULL ) AND RT.ACTIVE_FLAG = 'Y' AND (RT.TAX_CLASS = :B3 OR RT.TAX_CLASS IS NULL) AND EXISTS (SELECT 1 FROM ZX_SCO_TAXES_B_V TAX WHERE TAX.TAX_REGIME_CODE = RT.TAX_REGIME_CODE AND TAX.TAX = RT.TAX AND TAX.LIVE_FOR_PROCESSING_FLAG = 'Y' AND TAX.LIVE_FOR_APPLICABILITY_FLAG = 'Y') ) ORDER BY COMPOUNDING_PRECEDENCE |
| 37f1qguwxw0sk |
begin IF ( :v_msg_level:i_msg_level > 0 ) THEN arp_util . enable_debug ( 1000000 ) ; arp_global . msg_level := :v_msg_level:i_msg_level ; END IF ; arp_auto_accounting . g_error_buffer := NULL ; :v_num_failed_dist_rows:i_num_failed_dist_rows := 0 ; :v_coa_id:i_coa_id := arp_standard . gl_chart_of_accounts_id ; :v_retval:i_retval := 1 ; arp_auto_accounting . do_autoaccounting ( :v_mode:i_vmode , :v_account_class , :v_trx_id:i_trx_id , :v_line_id:i_line_id , :v_line_salesrep_id:i_line_salesrep_id , :v_request_id:i_request_id , :v_gl_date , :v_orig_gl_date , :v_total_trx_amount:i_total_trx_amount , :v_passed_ccid:i_passed_ccid , :v_force_acct_set_no , :v_cust_trx_type_id:i_cust_trx_type_id , :v_primary_salesrep_id:i_primary_salesrep_id , :v_inv_item_id:i_inv_item_id , :v_memo_line_id:i_memo_line_id , :v_ccid:i_ccid , :v_concat_segments:i_concat_segments , :v_num_failed_dist_rows:i_num_failed_dist_rows ) ; IF ( :v_mode:i_vmode = 'G' AND :v_ccid:i_ccid = -1 ) THEN :v_retval:i_retval := 0 ; END IF ; EXCEPTION WHEN arp_auto_accounting . no_ccid THEN :v_retval:i_retval := 0 ; WHEN NO_DATA_FOUND THEN NULL ; WHEN OTHERS THEN arp_util . debug ( 'arcdaa()' ) ; arp_util . debug ( SQLERRM ) ; :v_errorbuf:i_errorbuf := arp_auto_accounting . g_error_buffer ; :v_sqlcode:i_sqlcode := SQLCODE ; END ;
|
| 3b3psftuyks81 | BEGIN INV_TXNSTUB_PUB.postTransaction(:1, :2, :3); END; |
| 3wtnuzdm579hg | UPDATE RA_INTERFACE_LINES_GT SET PAYMENT_TRXN_EXTENSION_ID = :B2 WHERE CUSTOMER_TRX_ID = :B1 AND REQUEST_ID = FND_GLOBAL . CONC_REQUEST_ID AND RECEIPT_METHOD_ID IS NOT NULL |
| 4m7m0t6fjcs5x | update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1 |
| 4y08a52989vfk | BEGIN WSH_PICK_LIST.RELEASE_BATCH_SUB(:errbuf, :rc, :A0, :A1, :A2, :A3); END; |
| 4yak7x2zqz0dh | BEGIN inv_transfer_order_pvt.finalize_pick_confirm(:1, :2, :3, :4, :5, :6, :7); END; |
| 5t39uchjqpyfm | BEGIN xla_accounting_pkg.unit_processor_batch(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14); END; |
| 5t6wystf9zvbb | BEGIN OE_BULK_ORDER_IMPORT_PVT.ORDER_IMPORT_CONC_PGM(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4, :A5, :A6, :A7, :A8, :A9, :A10, :A11, :A12, :A13, :A14, :A15); END; |
| 608c0n36kaw62 | begin FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| 66wrj78kps6jm | UPDATE XLA_AE_LINES_GT AEL SET AEL.REF_EVENT_ID = -1 * AEL.REF_EVENT_ID , AEL.REF_AE_HEADER_ID = :B1 WHERE AEL.REF_AE_HEADER_ID = :B6 AND AEL.REF_EVENT_ID = -1 * :B5 AND AEL.TEMP_LINE_NUM < 0 AND AEL.LEDGER_ID = :B4 AND AEL.BALANCE_TYPE_CODE = :B3 AND AEL.REVERSAL_CODE = 'REVERSAL' AND AEL.HEADER_NUM = NVL( :B2 , 0) |
| 6abn0zw8kkvtk | begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :num_tax_failures , :return_status:i_return_status ) ; END ; |
| 6mu4cfrayu648 | SELECT 'x' FROM WSH_PR_WORKERS WHERE ROWID = :B1 AND PROCESSED = 'N' FOR UPDATE NOWAIT |
| 6ujg2sv6yp0w9 |
SELECT BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.UOM_CODE , DECODE(:B7 , -9999, NULL, :B7 ) LPN_ID , NULL SERIAL_NUMBER , SUM(BASE.PRIMARY_QUANTITY) , SUM(BASE.SECONDARY_QUANTITY) , BASE.GRADE_CODE , NULL CONSIST_STRING , BASE.DATE_RECEIVED ORDER_BY_STRING FROM WMS_TRX_DETAILS_TMP_V MPTDTV , ( SELECT X.ORGANIZATION_ID ORGANIZATION_ID , X.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , X.REVISION REVISION , X.LOT_NUMBER LOT_NUMBER , X.LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE SUBINVENTORY_CODE , X.LOCATOR_ID LOCATOR_ID , X.COST_GROUP_ID COST_GROUP_ID , X.STATUS_ID STATUS_ID , NULL SERIAL_NUMBER , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , X.GRADE_CODE GRADE_CODE , X.RESERVABLE_TYPE RESERVABLE_TYPE , X.LOCRESERVABLE LOCRESERVABLE , X.LOTRESERVABLE LOTRESERVABLE , NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) UOM_CODE , WMS_RULE_PVT.GETCONVERSIONRATE( NVL(LOC.PICK_UOM_CODE, SUB.PICK_UOM_CODE) , X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID) CONVERSION_RATE , NULL LOCATOR_INVENTORY_ITEM_ID , NULL EMPTY_FLAG , NULL LOCATION_CURRENT_UNITS FROM ( SELECT X.ORGANIZATION_ID , X.INVENTORY_ITEM_ID , X.REVISION , X.LOT_NUMBER , LOT.EXPIRATION_DATE LOT_EXPIRATION_DATE , X.SUBINVENTORY_CODE , SUB.RESERVABLE_TYPE , NVL(X.RESERVABLE_TYPE, 1) LOCRESERVABLE , NVL(LOT.RESERV
ABLE_TYPE, 1) LOTRESERVABLE , X.LOCATOR_ID , X.COST_GROUP_ID , X.STATUS_ID , X.DATE_RECEIVED DATE_RECEIVED , X.PRIMARY_QUANTITY PRIMARY_QUANTITY , X.SECONDARY_QUANTITY SECONDARY_QUANTITY , LOT.GRADE_CODE GRADE_CODE , X.LPN_ID LPN_ID , X.PROJECT_ID PROJECT_ID , X.TASK_ID TASK_ID FROM (SELECT MOQ.ORGANIZATION_ID , MOQ.INVENTORY_ITEM_ID , MOQ.REVISION , MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE , MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID , MOQ.STATUS_ID , MILS.RESERVABLE_TYPE , MIN(NVL(MOQ.ORIG_DATE_RECEIVED, MOQ.DATE_RECEIVED)) DATE_RECEIVED , SUM(MOQ.PRIMARY_TRANSACTION_QUANTITY) PRIMARY_QUANTITY , SUM(MOQ.SECONDARY_TRANSACTION_QUANTITY) SECONDARY_QUANTITY , MOQ.LPN_ID LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) PROJECT_ID , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) TASK_ID FROM MTL_ONHAND_QUANTITIES_DETAIL MOQ, MTL_ITEM_LOCATIONS MILS WHERE MOQ.ORGANIZATION_ID = :B2 AND MOQ.INVENTORY_ITEM_ID = :B1 AND MOQ.ORGANIZATION_ID = MILS.ORGANIZATION_ID (+) AND MOQ.SUBINVENTORY_CODE = MILS.SUBINVENTORY_CODE (+) AND MOQ.LOCATOR_ID = MILS.INVENTORY_LOCATION_ID (+) GROUP BY MOQ.ORGANIZATION_ID, MOQ.INVENTORY_ITEM_ID , MOQ.REVISION, MOQ.LOT_NUMBER , MOQ.SUBINVENTORY_CODE, MOQ.LOCATOR_ID , MOQ.COST_GROUP_ID, MOQ.STATUS_ID, MILS.RESERVABLE_TYPE, MOQ.LPN_ID , DECODE(MILS.PROJECT_ID, MILS.PROJECT_ID, MOQ.PROJECT_ID) , DECODE(MILS.TASK_ID, MILS.TASK_ID, MOQ.TASK_ID) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_LOT_NUMBERS LOT WHERE X.PRIMARY_QUANTITY > 0 AND X.OR
GANIZATION_ID = SUB.ORGANIZATION_ID AND X.SUBINVENTORY_CODE = SUB.SECONDARY_INVENTORY_NAME AND X.ORGANIZATION_ID = LOT.ORGANIZATION_ID (+) AND X.INVENTORY_ITEM_ID = LOT.INVENTORY_ITEM_ID (+) AND X.LOT_NUMBER = LOT.LOT_NUMBER (+) ) X , MTL_SECONDARY_INVENTORIES SUB , MTL_ITEM_LOCATIONS LOC WHERE X.ORGANIZATION_ID = LOC.ORGANIZATION_ID (+) AND X.LOCATOR_ID = LOC.INVENTORY_LOCATION_ID (+) AND SUB.ORGANIZATION_ID = X.ORGANIZATION_ID AND SUB.SECONDARY_INVENTORY_NAME = X.SUBINVENTORY_CODE ) BASE WHERE BASE.ORGANIZATION_ID = :B2 AND BASE.INVENTORY_ITEM_ID = :B1 AND DECODE(:B11 , '-9999', 'a', BASE.SUBINVENTORY_CODE) = DECODE(:B11 , '-9999', 'a', :B11 ) AND ((EXISTS (SELECT 1 FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B2 AND DEFAULT_STATUS_ID IS NOT NULL ) AND EXISTS(SELECT 1 FROM MTL_MATERIAL_STATUSES WHERE STATUS_ID = BASE.STATUS_ID AND RESERVABLE_TYPE = 1)) OR ((NOT EXISTS(SELECT 1 FROM MTL_PARAMETERS WHERE ORGANIZATION_ID = :B2 AND DEFAULT_STATUS_ID IS NOT NULL) OR BASE.STATUS_ID IS NULL) AND DECODE(:B11 , '-9999', BASE.RESERVABLE_TYPE, 1) = 1)) AND DECODE(:B10 , -9999, 1, BASE.LOCATOR_ID) = DECODE(:B10 , -9999, 1, :B10 ) AND DECODE(:B9 , '-99', 'a', BASE.REVISION) = DECODE(:B9 , '-99', 'a', :B9 ) AND DECODE(:B8 , '-9999', 'a', BASE.LOT_NUMBER) = DECODE(:B8 , '-9999', 'a', :B8 ) AND DECODE(:B7 , -9999, 1, BASE.LPN_ID) = DECODE(:B7 , -9999, 1, :B7 ) AND DECODE(:B6 , -9999, 1, BASE.COST_GROUP_ID) = DECODE(:B6 , -9999, 1, :B6 ) AND (DECODE(:B5
, -9999, -1, BASE.PROJECT_ID) = DECODE(:B5 , -9999, -1, :B5 ) OR ( :B5 = -7777 AND BASE.PROJECT_ID IS NULL)) AND (:B5 = -9999 OR NVL(BASE.TASK_ID, -9999) = :B4 OR (:B4 = -7777 AND BASE.TASK_ID IS NULL)) AND MPTDTV.PP_TRANSACTION_TEMP_ID = :B3 GROUP BY BASE.ORGANIZATION_ID , BASE.INVENTORY_ITEM_ID , BASE.REVISION , BASE.LOT_NUMBER , BASE.LOT_EXPIRATION_DATE , BASE.SUBINVENTORY_CODE , BASE.LOCATOR_ID , BASE.COST_GROUP_ID , BASE.PROJECT_ID , BASE.TASK_ID , BASE.UOM_CODE , BASE.GRADE_CODE , BASE.DATE_RECEIVED, BASE.SERIAL_NUMBER, BASE.CONVERSION_RATE , BASE.DATE_RECEIVED ORDER BY BASE.DATE_RECEIVED DESC , BASE.SERIAL_NUMBER ASC, BASE.CONVERSION_RATE DESC |
| 76sw2a4vnc89j | begin FND_FLEX_WORKFLOW_APIS.START_GENERATION (:v1, :v2, :v3, :v4, :v5); end; |
| 7bdg2fscmus2h |
SELECT ACCOUNTING_RULE_ID , ACCOUNTING_RULE_DURATION , ACTUAL_ARRIVAL_DATE , ACTUAL_SHIPMENT_DATE , AGREEMENT_ID , ARRIVAL_SET_ID , ATO_LINE_ID , ATTRIBUTE1 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE2 , ATTRIBUTE20 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , AUTO_SELECTED_QUANTITY , AUTHORIZED_TO_SHIP_FLAG , BOOKED_FLAG , CANCELLED_FLAG , CANCELLED_QUANTITY , COMPONENT_CODE , COMPONENT_NUMBER , COMPONENT_SEQUENCE_ID , CONFIG_HEADER_ID , CONFIG_REV_NBR , CONFIG_DISPLAY_SEQUENCE , CONFIGURATION_ID , CONTEXT , CREATED_BY , CREATION_DATE , CREDIT_INVOICE_LINE_ID , CUSTOMER_DOCK_CODE , CUSTOMER_JOB , CUSTOMER_PRODUCTION_LINE , CUST_PRODUCTION_SEQ_NUM , CUSTOMER_TRX_LINE_ID , CUST_MODEL_SERIAL_NUMBER , CUST_PO_NUMBER , CUSTOMER_LINE_NUMBER , CUSTOMER_SHIPMENT_NUMBER , CUSTOMER_ITEM_NET_PRICE , DELIVERY_LEAD_TIME , DELIVER_TO_CONTACT_ID , DELIVER_TO_ORG_ID , DEMAND_BUCKET_TYPE_CODE , DEMAND_CLASS_CODE , DEP_PLAN_REQUIRED_FLAG , EARLIEST_ACCEPTABLE_DATE , END_ITEM_UNIT_NUMBER , EXPLOSION_DATE , FIRST_ACK_CODE , FIRST_ACK_DATE , FOB_POINT_CODE , FREIGHT_CARRIER_CODE , FREIGHT_TERMS_CODE , FULFILLED_QUANTITY , FULFILLED_FLAG , FULFILLMENT_METHOD_CODE , FULFILLMENT_DATE , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOB
AL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE_CATEGORY , HEADER_ID , INDUSTRY_ATTRIBUTE1 , INDUSTRY_ATTRIBUTE10 , INDUSTRY_ATTRIBUTE11 , INDUSTRY_ATTRIBUTE12 , INDUSTRY_ATTRIBUTE13 , INDUSTRY_ATTRIBUTE14 , INDUSTRY_ATTRIBUTE15 , INDUSTRY_ATTRIBUTE16 , INDUSTRY_ATTRIBUTE17 , INDUSTRY_ATTRIBUTE18 , INDUSTRY_ATTRIBUTE19 , INDUSTRY_ATTRIBUTE20 , INDUSTRY_ATTRIBUTE21 , INDUSTRY_ATTRIBUTE22 , INDUSTRY_ATTRIBUTE23 , INDUSTRY_ATTRIBUTE24 , INDUSTRY_ATTRIBUTE25 , INDUSTRY_ATTRIBUTE26 , INDUSTRY_ATTRIBUTE27 , INDUSTRY_ATTRIBUTE28 , INDUSTRY_ATTRIBUTE29 , INDUSTRY_ATTRIBUTE30 , INDUSTRY_ATTRIBUTE2 , INDUSTRY_ATTRIBUTE3 , INDUSTRY_ATTRIBUTE4 , INDUSTRY_ATTRIBUTE5 , INDUSTRY_ATTRIBUTE6 , INDUSTRY_ATTRIBUTE7 , INDUSTRY_ATTRIBUTE8 , INDUSTRY_ATTRIBUTE9 , INDUSTRY_CONTEXT , INTMED_SHIP_TO_CONTACT_ID , INTMED_SHIP_TO_ORG_ID , INVENTORY_ITEM_ID , INVOICE_INTERFACE_STATUS_CODE , INVOICE_TO_CONTACT_ID , INVOICE_TO_ORG_ID , INVOICED_QUANTITY , INVOICING_RULE_ID , ORDERED_ITEM_ID , ITEM_IDENTIFIER_TYPE , ORDERED_ITEM , ITEM_REVISION , ITEM_TYPE_CODE , LAST_ACK_CODE , LAST_ACK_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN , LAT
EST_ACCEPTABLE_DATE , LINE_CATEGORY_CODE , LINE_ID , LINE_NUMBER , LINE_TYPE_ID , LINK_TO_LINE_ID , MODEL_GROUP_NUMBER , MFG_LEAD_TIME , OPEN_FLAG , OPTION_FLAG , OPTION_NUMBER , ORDERED_QUANTITY , ORDERED_QUANTITY2 , ORDER_QUANTITY_UOM , ORDERED_QUANTITY_UOM2 , ORG_ID , ORIG_SYS_DOCUMENT_REF , ORIG_SYS_LINE_REF , ORIG_SYS_SHIPMENT_REF , OVER_SHIP_REASON_CODE , OVER_SHIP_RESOLVED_FLAG , PAYMENT_TERM_ID , PLANNING_PRIORITY , PREFERRED_GRADE , PRICE_LIST_ID , PRICE_REQUEST_CODE , PRICING_ATTRIBUTE1 , PRICING_ATTRIBUTE10 , PRICING_ATTRIBUTE2 , PRICING_ATTRIBUTE3 , PRICING_ATTRIBUTE4 , PRICING_ATTRIBUTE5 , PRICING_ATTRIBUTE6 , PRICING_ATTRIBUTE7 , PRICING_ATTRIBUTE8 , PRICING_ATTRIBUTE9 , PRICING_CONTEXT , PRICING_DATE , PRICING_QUANTITY , PRICING_QUANTITY_UOM , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , PROJECT_ID , PROMISE_DATE , RE_SOURCE_FLAG , REFERENCE_CUSTOMER_TRX_LINE_ID , REFERENCE_HEADER_ID , REFERENCE_LINE_ID , REFERENCE_TYPE , REQUEST_DATE , REQUEST_ID , RETURN_ATTRIBUTE1 , RETURN_ATTRIBUTE10 , RETURN_ATTRIBUTE11 , RETURN_ATTRIBUTE12 , RETURN_ATTRIBUTE13 , RETURN_ATTRIBUTE14 , RETURN_ATTRIBUTE15 , RETURN_ATTRIBUTE2 , RETURN_ATTRIBUTE3 , RETURN_ATTRIBUTE4 , RETURN_ATTRIBUTE5 , RETURN_ATTRIBUTE6 , RETURN_ATTRIBUTE7 , RETURN_ATTRIBUTE8 , RETURN_ATTRIBUTE9 , RETURN_CONTEXT , RETURN_REASON_CODE , RLA_SCHEDULE_TYPE_CODE , SALESREP_ID , SCHEDULE_ARRIVAL_DATE , SCHEDULE_SHIP_DATE , SCHED
ULE_STATUS_CODE , SHIPMENT_NUMBER , SHIPMENT_PRIORITY_CODE , SHIPPED_QUANTITY , SHIPPED_QUANTITY2 , SHIPPING_METHOD_CODE , SHIPPING_QUANTITY , SHIPPING_QUANTITY2 , SHIPPING_QUANTITY_UOM , SHIPPING_QUANTITY_UOM2 , SHIP_FROM_ORG_ID , SUBINVENTORY , SHIP_SET_ID , SHIP_TOLERANCE_ABOVE , SHIP_TOLERANCE_BELOW , SHIPPABLE_FLAG , SHIPPING_INTERFACED_FLAG , SHIP_TO_CONTACT_ID , SHIP_TO_ORG_ID , SHIP_MODEL_COMPLETE_FLAG , SOLD_TO_ORG_ID , SOLD_FROM_ORG_ID , SORT_ORDER , SOURCE_DOCUMENT_ID , SOURCE_DOCUMENT_LINE_ID , SOURCE_DOCUMENT_TYPE_ID , SOURCE_TYPE_CODE , SPLIT_FROM_LINE_ID , LINE_SET_ID , SPLIT_BY , MODEL_REMNANT_FLAG , TASK_ID , TAX_CODE , TAX_DATE , TAX_EXEMPT_FLAG , TAX_EXEMPT_NUMBER , TAX_EXEMPT_REASON_CODE , TAX_POINT_CODE , TAX_RATE , TAX_VALUE , TOP_MODEL_LINE_ID , UNIT_LIST_PRICE , UNIT_LIST_PRICE_PER_PQTY , UNIT_SELLING_PRICE , UNIT_SELLING_PRICE_PER_PQTY , VISIBLE_DEMAND_FLAG , VEH_CUS_ITEM_CUM_KEY_ID , SHIPPING_INSTRUCTIONS , PACKING_INSTRUCTIONS , SERVICE_TXN_REASON_CODE , SERVICE_TXN_COMMENTS , SERVICE_DURATION , SERVICE_PERIOD , SERVICE_START_DATE , SERVICE_END_DATE , SERVICE_COTERMINATE_FLAG , UNIT_LIST_PERCENT , UNIT_SELLING_PERCENT , UNIT_PERCENT_BASE_PRICE , SERVICE_NUMBER , SERVICE_REFERENCE_TYPE_CODE , SERVICE_REFERENCE_LINE_ID , SERVICE_REFERENCE_SYSTEM_ID , TP_CONTEXT , TP_ATTRIBUTE1 , TP_ATTRIBUTE2 , TP_ATTRIBUTE3 , TP_ATTRIBUTE4 , TP_ATTRIBUTE5 , TP_ATTRIBUTE6 , TP_ATTRIBUTE7 , TP_ATTRI
BUTE8 , TP_ATTRIBUTE9 , TP_ATTRIBUTE10 , TP_ATTRIBUTE11 , TP_ATTRIBUTE12 , TP_ATTRIBUTE13 , TP_ATTRIBUTE14 , TP_ATTRIBUTE15 , FLOW_STATUS_CODE , MARKETING_SOURCE_CODE_ID , CALCULATE_PRICE_FLAG , COMMITMENT_ID , ORDER_SOURCE_ID , UPGRADED_FLAG , ORIGINAL_INVENTORY_ITEM_ID , ORIGINAL_ITEM_IDENTIFIER_TYPE , ORIGINAL_ORDERED_ITEM_ID , ORIGINAL_ORDERED_ITEM , ITEM_RELATIONSHIP_TYPE , ITEM_SUBSTITUTION_TYPE_CODE , LATE_DEMAND_PENALTY_FACTOR , OVERRIDE_ATP_DATE_CODE , FIRM_DEMAND_FLAG , EARLIEST_SHIP_DATE , USER_ITEM_DESCRIPTION , BLANKET_NUMBER , BLANKET_LINE_NUMBER , BLANKET_VERSION_NUMBER , UNIT_COST , LOCK_CONTROL , CHANGE_SEQUENCE , TRANSACTION_PHASE_CODE , SOURCE_DOCUMENT_VERSION_NUMBER , MINISITE_ID , IB_OWNER , IB_INSTALLED_AT_LOCATION , IB_CURRENT_LOCATION , END_CUSTOMER_ID , END_CUSTOMER_CONTACT_ID , END_CUSTOMER_SITE_USE_ID , RETROBILL_REQUEST_ID , ORIGINAL_LIST_PRICE , ORDER_FIRMED_DATE , ACTUAL_FULFILLMENT_DATE , CHARGE_PERIODICITY_CODE , CANCELLED_QUANTITY2 , FULFILLED_QUANTITY2 , CONTINGENCY_ID , REVREC_EVENT_CODE , REVREC_EXPIRATION_DAYS , ACCEPTED_QUANTITY , REVREC_COMMENTS , REVREC_SIGNATURE , REVREC_SIGNATURE_DATE , ACCEPTED_BY , REVREC_REFERENCE_DOCUMENT , REVREC_IMPLICIT_FLAG FROM OE_ORDER_LINES_ALL WHERE LINE_ID = :B1
|
| 7gtztzv329wg0 | select c.name, u.name from con$ c, cdef$ cd, user$ u where c.con# = cd.con# and cd.enabled = :1 and c.owner# = u.user# |
| 7ptvbaycjtbg4 | BEGIN arp_run.revenue_recognition(:errbuf, :rc, :A0, :A1, :A2); END; |
| 7qh9zcbrq9ky7 | SELECT 'Y' FROM WSH_PR_WORKERS WHERE ROWID = :B1 AND PROCESSED = 'N' FOR UPDATE NOWAIT |
| 8zfgv4ck11dw9 | BEGIN WF_ENGINE.BACKGROUNDCONCURRENT(:errbuf, :rc, :A0, :A1, :A2, :A3, :A4); END; |
| 9d8w3myb2h8bs | SELECT TAX_REGIME_CODE, TAX, TAX_STATUS_CODE, TAX_RATE_CODE, TAX_RATE_ID, EFFECTIVE_FROM, EFFECTIVE_TO, RATE_TYPE_CODE, PERCENTAGE_RATE, QUANTITY_RATE, ALLOW_ADHOC_TAX_RATE_FLAG, UOM_CODE, TAX_JURISDICTION_CODE, OFFSET_TAX, OFFSET_STATUS_CODE, OFFSET_TAX_RATE_CODE, ALLOW_EXEMPTIONS_FLAG, ALLOW_EXCEPTIONS_FLAG, NULL TAX_JURISDICTION_ID, DEF_REC_SETTLEMENT_OPTION_CODE, TAXABLE_BASIS_FORMULA_CODE, ADJ_FOR_ADHOC_AMT_CODE, INCLUSIVE_TAX_FLAG, TAX_CLASS FROM ZX_SCO_RATES_B_V WHERE TAX_REGIME_CODE = :B7 AND TAX = :B6 AND TAX_STATUS_CODE = :B5 AND ACTIVE_FLAG = 'Y' AND (TAX_JURISDICTION_CODE = :B4 ) AND TAX_RATE_CODE = :B3 AND (TAX_CLASS = :B2 OR TAX_CLASS IS NULL) AND ( :B1 >= EFFECTIVE_FROM AND (:B1 <= EFFECTIVE_TO OR EFFECTIVE_TO IS NULL)) ORDER BY TAX_CLASS NULLS LAST, SUBSCRIPTION_LEVEL_CODE |
| a40f9h91scg23 | select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and CODE_COMBINATION_ID = :FND_BIND2 |
| akz2hmcq2mppg |
INSERT ALL WHEN (ZX_LOCATION_MISSING = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LOCATION_MISSING', :B30 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_LINE_CLASS_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LINE_CLASS_INVALID', :B29 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_TRX_LINE_TYPE_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_LINE_TYPE_INVALID', :B28 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_LINE_AMT_INCL_TAX_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, T
RX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LINE_AMT_INCTAX_INVALID', :B27 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_CATEG_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_CATEG_NOT_EXIST', :B26 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_CATEG_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_CATEG_NOT_EFFECTIVE', :B25 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_CATEG_COUNTRY_INCONSIS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE
_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_CATEG_COUNTRY_INCON', :B24 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (USER_DEF_FC_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_USER_DEF_FC_CODE_NOT_EXIST', :B23 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (USER_DEF_FC_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_USER_DEF_FC_CODE_NOT_EFFECT', :B22 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (USER_DEF_COUNTRY_INCONSIS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE,
TRX_ID, TRX_LINE_ID, NULL, 'ZX_USER_DEF_COUNTRY_INCONSIS', :B21 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (DOC_FC_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_DOC_FC_CODE_NOT_EFFECTIVE', :B20 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TRX_BIZ_FC_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_BIZ_FC_CODE_NOT_EXIST', :B19 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TRX_BIZ_FC_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_BIZ_FC_CODE_NOT_EFFECT', :B18 , TRX_LEVEL_TYPE, INTERFACE_LI
NE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TRX_BIZ_FC_COUNTRY_INCONSIS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TRX_BIZ_FC_COUNTRY_INCONSIS', :B17 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (INTENDED_USE_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INTENDED_USE_CODE_NOT_EXIST', :B16 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (INTENDED_USE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INTENDED_USE_NOT_EFFECTIVE', :B15 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (INTENDED_USE_CONTRY_INCONSIS = 'Y') THEN INTO ZX_VALID
ATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INTENDED_USE_COUNTRY_INCON', :B14 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_TYPE_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_TYPE_CODE_NOT_EXIST', :B13 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_TYPE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_TYPE_NOT_EFFECTIVE', :B12 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (PRODUCT_FC_CODE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_T
AX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_FC_CODE_NOT_EXIST', :B11 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_LINE_CTRL_AMT_NOT_NULL = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_LINE_CTRL_AMT_NOT_NULL', :B10 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_EXEMPTION_CTRL_FLAG_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_EXEMPTION_CTRL_FLAG_INVALID', :B9 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_PRODUCT_TYPE_INVALID = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE
_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_PRODUCT_TYPE_INVALID', :B8 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_TAX_LINES = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_TAX_LINES', :B7 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_LINE_TAX_AMT = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_LINE_TAX_AMT', :B6 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_TAX_FOR_ALLOC_FLG = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_TAX_FOR_ALLOC_FLG', :B5 ,
TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (ZX_INVALID_TAX_ONLY_TAX_LINES = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_INVALID_TAX_ONLY_TAX_LINES', :B4 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (TAX_RATE_NOT_EXISTS = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TAX_RATE_NOT_EXIST', :B3 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (NVL(TAX_RATE_NOT_EXISTS, 'N') <> 'Y' AND TAX_RATE_CODE_NOT_EFFECTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TAX_RATE_NOT_EFFECTIVE', :B2 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) WHEN (
NVL(TAX_RATE_NOT_EXISTS, 'N') <> 'Y' AND TAX_RATE_CODE_NOT_ACTIVE = 'Y') THEN INTO ZX_VALIDATION_ERRORS_GT( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, SUMMARY_TAX_LINE_NUMBER, MESSAGE_NAME, MESSAGE_TEXT, TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) VALUES( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, NULL, 'ZX_TAX_RATE_NOT_ACTIVE', :B1 , TRX_LEVEL_TYPE, INTERFACE_LINE_ENTITY_CODE, INTERFACE_LINE_ID ) SELECT HEADER.APPLICATION_ID, HEADER.ENTITY_CODE, HEADER.EVENT_CLASS_CODE, HEADER.TRX_ID, LINES_GT.TRX_LINE_ID, LINES_GT.TRX_LINE_ID INTERFACE_LINE_ID , LINES_GT.ENTITY_CODE INTERFACE_LINE_ENTITY_CODE, LINES_GT.TRX_LEVEL_TYPE, CASE WHEN (LINES_GT.SHIP_FROM_LOCATION_ID IS NOT NULL OR LINES_GT.SHIP_TO_LOCATION_ID IS NOT NULL OR LINES_GT.POA_LOCATION_ID IS NOT NULL OR LINES_GT.POO_LOCATION_ID IS NOT NULL OR LINES_GT.PAYING_LOCATION_ID IS NOT NULL OR LINES_GT.OWN_HQ_LOCATION_ID IS NOT NULL OR LINES_GT.TRADING_HQ_LOCATION_ID IS NOT NULL OR LINES_GT.POC_LOCATION_ID IS NOT NULL OR LINES_GT.POI_LOCATION_ID IS NOT NULL OR LINES_GT.POD_LOCATION_ID IS NOT NULL OR LINES_GT.BILL_TO_LOCATION_ID IS NOT NULL OR LINES_GT.BILL_FROM_LOCATION_ID IS NOT NULL OR LINES_GT.TITLE_TRANSFER_LOCATION_ID IS NOT NULL) THEN NULL ELSE 'Y' END ZX_LOCATION_MISSING, NVL2(LINES_GT.LINE_CLASS, CASE WHEN (NOT EXISTS (SELECT 1 FROM FND_LOOKUPS LKP WHERE LINES_GT.LINE_CLASS = LKP.LOOKUP_CODE AND LKP.LOOKUP_TYPE = 'ZX_
LINE_CLASS')) THEN 'Y' ELSE NULL END, NULL ) ZX_LINE_CLASS_INVALID, CASE WHEN (LINES_GT.TRX_LINE_TYPE NOT IN('ITEM', 'FREIGHT', 'MISC', 'MISCELLANEOUS')) THEN 'Y' ELSE NULL END ZX_TRX_LINE_TYPE_INVALID, CASE WHEN (LINES_GT.LINE_AMT_INCLUDES_TAX_FLAG IS NULL OR LINES_GT.LINE_AMT_INCLUDES_TAX_FLAG NOT IN ('A', 'N', 'S')) THEN 'Y' ELSE NULL END ZX_LINE_AMT_INCL_TAX_INVALID, NVL2(LINES_GT.PRODUCT_CATEGORY, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL ) PRODUCT_CATEG_NOT_EXISTS, CASE WHEN LINES_GT.PRODUCT_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)))) THEN 'Y' ELSE NULL END ELSE NULL END PRODUCT_CATEG_NOT_EFFECTIVE, CASE WHEN LINES_GT.PRODUCT_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND COUNTRY_CODE IS NOT NULL)
) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_CATEGORY AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END PRODUCT_CATEG_COUNTRY_INCONSIS, NVL2(LINES_GT.USER_DEFINED_FISC_CLASS, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL) USER_DEF_FC_CODE_NOT_EXISTS, CASE WHEN LINES_GT.USER_DEFINED_FISC_CLASS IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)))) THEN 'Y' ELSE NULL END ELSE NULL END USER_DEF_FC_CODE_NOT_EFFECTIVE, CASE WHEN LINES_GT.USER_DEFINED_FISC_CLASS IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE CLASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND COUNTRY_CODE IS NOT NULL)) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_USER_DEFINED_V WHERE C
LASSIFICATION_CODE = LINES_GT.USER_DEFINED_FISC_CLASS AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END USER_DEF_COUNTRY_INCONSIS, CASE WHEN HEADER.DOCUMENT_SUB_TYPE IS NOT NULL AND FC_DOC.CLASSIFICATION_CODE IS NOT NULL THEN CASE WHEN ( LINES_GT.TAX_DATE NOT BETWEEN FC_DOC.EFFECTIVE_FROM AND NVL(FC_DOC.EFFECTIVE_TO, LINES_GT.TAX_DATE) AND (NOT EXISTS (SELECT 1 FROM ZX_TRANSACTION_LINES_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID < LINES_GT.TRX_LINE_ID AND TRX_LEVEL_TYPE = LINES_GT.TRX_LEVEL_TYPE))) THEN 'Y' ELSE NULL END ELSE NULL END DOC_FC_CODE_NOT_EFFECTIVE, NVL2(LINES_GT.TRX_BUSINESS_CATEGORY, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.TRX_BUSINESS_CATEGORY AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE))))) AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL ) TRX_BIZ_FC_CODE_NOT_EXISTS, CASE WHEN LINES_GT.TRX_BUSINESS_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.TRX_BUSINESS_CATEGORY AND (APPLICATION_ID IS NULL
OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE))))) AND (COUNTRY_CODE IS NOT NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.TRX_BUSINESS_CATEGORY AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE))))) AND (COUNTRY_CODE IS NOT NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)))) THEN 'Y' ELSE NULL END ELSE NULL END TRX_BIZ_FC_CODE_NOT_EFFECTIVE, CASE WHEN LINES_GT.TRX_BUSINESS_CATEGORY IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.TRX_BUSINESS_CATEGORY AND (APPLICATION_ID IS NULL OR (APPLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE))))) AND COUNTRY_CODE IS NOT NULL)) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_BUSINESS_CATEGORIES_V WHERE CLASSIFICATION_CODE = LINES_GT.TRX_BUSINESS_CATEGORY AND (APPLICATION_ID IS NULL OR (AP
PLICATION_ID = LINES_GT.APPLICATION_ID AND (ENTITY_CODE IS NULL OR (ENTITY_CODE = LINES_GT.ENTITY_CODE AND (EVENT_CLASS_CODE IS NULL OR EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE))))) AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END TRX_BIZ_FC_COUNTRY_INCONSIS, NVL2(LINES_GT.LINE_INTENDED_USE, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL) INTENDED_USE_CODE_NOT_EXISTS, CASE WHEN LINES_GT.LINE_INTENDED_USE IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY) AND NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE) BETWEEN EFFECTIVE_FROM AND NVL(EFFECTIVE_TO, NVL(LINES_GT.TRX_LINE_DATE, HEADER.TRX_DATE)))) THEN 'Y' ELSE NULL END ELSE NULL END INTENDED_USE_NOT_EFFECTIVE, CASE WHEN LINES_GT.LINE_INTENDED_USE IS NOT NULL AND (EXISTS (SELECT 1 FROM ZX_FC_INTENDED_USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND COUNTRY_CODE IS NOT NULL)) THEN CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_INTENDED_
USE_V WHERE CLASSIFICATION_CODE = LINES_GT.LINE_INTENDED_USE AND COUNTRY_CODE IS NOT NULL AND COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY)) THEN 'Y' ELSE NULL END ELSE NULL END INTENDED_USE_CONTRY_INCONSIS, NVL2(LINES_GT.PRODUCT_TYPE, NVL(FND.LOOKUP_CODE, 'Y'), NULL ) PRODUCT_TYPE_CODE_NOT_EXISTS, CASE WHEN (FND.LOOKUP_CODE IS NOT NULL) THEN CASE WHEN ( LINES_GT.TAX_DATE BETWEEN FND.START_DATE_ACTIVE AND NVL(FND.END_DATE_ACTIVE, LINES_GT.TAX_DATE ) ) THEN NULL ELSE 'Y' END ELSE NULL END PRODUCT_TYPE_NOT_EFFECTIVE, NVL2(LINES_GT.PRODUCT_FISC_CLASSIFICATION, CASE WHEN (NOT EXISTS (SELECT 1 FROM ZX_FC_PRODUCT_FISCAL_V WHERE CLASSIFICATION_CODE = LINES_GT.PRODUCT_FISC_CLASSIFICATION AND (COUNTRY_CODE IS NULL OR COUNTRY_CODE = HEADER.DEFAULT_TAXATION_COUNTRY))) THEN 'Y' ELSE NULL END, NULL) PRODUCT_FC_CODE_NOT_EXISTS, CASE WHEN (LINES_GT.LINE_LEVEL_ACTION <> 'CREATE' AND LINES_GT.CTRL_TOTAL_LINE_TX_AMT IS NOT NULL ) THEN 'Y' ELSE NULL END ZX_LINE_CTRL_AMT_NOT_NULL, CASE WHEN (LINES_GT.EXEMPTION_CONTROL_FLAG IS NOT NULL AND LINES_GT.EXEMPTION_CONTROL_FLAG NOT IN ('R', 'S', 'E')) THEN 'Y' ELSE NULL END ZX_EXEMPTION_CTRL_FLAG_INVALID, CASE WHEN (LINES_GT.PRODUCT_TYPE IS NOT NULL AND LINES_GT.PRODUCT_TYPE NOT IN ('GOODS', 'SERVICES')) THEN 'Y' ELSE NULL END ZX_PRODUCT_TYPE_INVALID, CASE WHEN (LINES_GT.CTRL_HDR_TX_APPL_FLAG = 'Y' AND LINES_GT.LINE_LEVEL_ACTION <> 'LINE_INFO_TAX_ONLY' AND EXISTS (SELECT 1 FROM ZX_IMPORT_TAX_LINES_GT IMPTAXES_GT WHERE APPLICATI
ON_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID = LINES_GT.TRX_LINE_ID) ) THEN 'Y' ELSE NULL END ZX_INVALID_TAX_LINES, CASE WHEN (LINES_GT.CTRL_TOTAL_LINE_TX_AMT IS NOT NULL AND EXISTS (SELECT 1 FROM ZX_TRX_TAX_LINK_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID = LINES_GT.TRX_LINE_ID AND TRX_LEVEL_TYPE = LINES_GT.TRX_LEVEL_TYPE) ) THEN 'Y' ELSE NULL END ZX_INVALID_LINE_TAX_AMT, CASE WHEN (LINES_GT.CTRL_TOTAL_LINE_TX_AMT IS NOT NULL AND EXISTS(SELECT 1 FROM ZX_IMPORT_TAX_LINES_GT IMPTAXES_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID IS NULL AND IMPTAXES_GT.TAX_LINE_ALLOCATION_FLAG = 'N') ) THEN 'Y' ELSE NULL END ZX_INVALID_TAX_FOR_ALLOC_FLG, CASE WHEN (LINES_GT.LINE_LEVEL_ACTION = 'LINE_INFO_TAX_ONLY' AND EXISTS (SELECT 1 FROM ZX_IMPORT_TAX_LINES_GT IMPTAXES_GT WHERE APPLICATION_ID = LINES_GT.APPLICATION_ID AND ENTITY_CODE = LINES_GT.ENTITY_CODE AND EVENT_CLASS_CODE = LINES_GT.EVENT_CLASS_CODE AND TRX_ID = LINES_GT.TRX_ID AND TRX_LINE_ID = LINES_GT.TRX_LINE_ID AND IMPTAXES_GT.TAX_LINE_ALLOCATION_FLAG <> 'Y') ) THEN 'Y' ELSE NULL END ZX_INVALID_TAX_ONLY_TAX_LINES, CASE WHEN LINES_GT.
OUTPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99)) THEN 'Y' ELSE CASE WHEN LINES_GT.INPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.INPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99)) THEN 'Y' ELSE NULL END END TAX_RATE_NOT_EXISTS, CASE WHEN LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND LINES_GT.TAX_DATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, LINES_GT.TAX_DATE)) THEN 'Y' ELSE CASE WHEN LINES_GT.INPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.INPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND LINES_GT.TAX_DATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, LINES_GT.TAX_DATE)) THEN 'Y' ELSE NULL END END TAX_RATE_CODE_NOT_EFFECTIVE, CASE WHEN LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_OUTPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.OUTPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND ENABLED_FLAG = 'Y') THEN 'Y'
ELSE CASE WHEN LINES_GT.INPUT_TAX_CLASSIFICATION_CODE IS NOT NULL AND NOT EXISTS (SELECT 1 FROM ZX_INPUT_CLASSIFICATIONS_V WHERE LOOKUP_CODE = LINES_GT.INPUT_TAX_CLASSIFICATION_CODE AND ORG_ID IN (HEADER.INTERNAL_ORGANIZATION_ID, -99) AND ENABLED_FLAG = 'Y') THEN 'Y' ELSE NULL END END TAX_RATE_CODE_NOT_ACTIVE FROM ZX_TRX_HEADERS_GT HEADER, ZX_EVNT_CLS_MAPPINGS EVNTMAP, ZX_TRANSACTION_LINES_GT LINES_GT, ZX_FC_DOCUMENT_FISCAL_V FC_DOC, FND_LOOKUPS FND WHERE LINES_GT.TRX_ID = HEADER.TRX_ID AND LINES_GT.APPLICATION_ID = HEADER.APPLICATION_ID AND LINES_GT.ENTITY_CODE = HEADER.ENTITY_CODE AND LINES_GT.EVENT_CLASS_CODE = HEADER.EVENT_CLASS_CODE AND FC_DOC.CLASSIFICATION_CODE(+) = HEADER.DOCUMENT_SUB_TYPE AND FC_DOC.COUNTRY_CODE(+) = HEADER.DEFAULT_TAXATION_COUNTRY AND HEADER.APPLICATION_ID = EVNTMAP.APPLICATION_ID (+) AND HEADER.ENTITY_CODE = EVNTMAP.ENTITY_CODE (+) AND HEADER.EVENT_CLASS_CODE = EVNTMAP.EVENT_CLASS_CODE(+) AND FND.LOOKUP_TYPE(+) = 'ZX_PRODUCT_TYPE' AND FND.LOOKUP_CODE(+) = LINES_GT.PRODUCT_TYPE |
| assndb4wqnd6r | BEGIN INV_TXN_MANAGER_PUB.rel_reservations_mrp_update(:1, :2, :3, :4, :5, :6, :7); END; |
| bf7uwg5pa3pj6 | begin FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION (:v1, :v2, :v3, :v4, :v5); end; |
| bsuw7pmwrufpy |
SELECT
reservation_id
, primary_reservation_quantity - NVL(detailed_quantity, 0)
, NVL(secondary_reservation_quantity, 0) - NVL(secondary_detailed_quantity, 0) -- INVCONV
FROM mtl_reservations
WHERE demand_source_header_id = :demand_source_header_id
AND demand_source_line_id = :demand_source_line_id
AND demand_source_type_id = :demand_source_type_id
AND supply_source_type_id = :supply_source_type_id
AND (:demand_source_delivery = :l_miss_num
OR :demand_source_delivery IS NULL
AND demand_source_delivery IS NULL
OR :demand_source_delivery = demand_source_delivery)
AND (:organization_id = :l_miss_num
OR :organization_id IS NULL
AND organization_id IS NULL
OR :organization_id = organization_id)
AND (:inventory_item_id = :l_miss_num
OR :inventory_item_id IS NULL
AND inventory_item_id IS NULL
OR :inventory_item_id = inventory_item_id)
AND (:subinventory_code = :l_miss_char
OR :subinventory_code IS NULL
AND subinventory_code IS NULL
OR :subinventory_code = subinventory_code)
AND (:locator_id = :l_miss_num
OR :locator_id IS NULL
AND locator_id IS NULL
OR :locator_id = locator_id)
AND (:lot_number = :l_miss_char
OR :lot_number IS NULL
AND lot_number IS NULL
OR :lot_number = lot_number)
AND (:revision = :l_miss_char
OR :revision
IS NULL
AND revision IS NULL
OR :revision = revision)
AND (:lpn_id = :l_miss_num
OR ((lpn_id IS NULL) OR (:lpn_id = lpn_id)))
AND (:demand_source_name = :l_miss_char
OR :demand_source_name IS NULL
AND demand_source_name IS NULL
OR :demand_source_name = demand_source_name)
AND (primary_reservation_quantity - NVL(detailed_quantity, 0)) > 0
ORDER BY NVL(lpn_id, 0) DESC, reservation_id FOR UPDATE |
| ccpt6a6djarcv |
UPDATE RA_INTERFACE_LINES IL SET PAYMENT_ATTRIBUTES = (SELECT CASE WHEN AUTHORIZED_FLAG = 'Y' THEN CASE WHEN SUM(DECODE(AUTH.SETTLE_REQ_AUTH_FLAG, 'Y', 1, 0)) > 0 THEN 'PERSISTENT-AUTH~' || EXT.INSTR_ASSIGNMENT_ID || '~' || EXT.TRXN_EXTENSION_ID ELSE 'NON-PERSISTENT-AUTH~' || EXT.INSTR_ASSIGNMENT_ID || '~' END ELSE 'NO-AUTH~' || EXT.INSTR_ASSIGNMENT_ID || '~' END FROM IBY_FNDCPT_TX_EXTENSIONS EXT, (SELECT /*+ leading(op) use_nl(summ, seft, ueft) */ OP.TRXN_EXTENSION_ID, DECODE(DECODE(SUMM.STATUS, 0, 'Y', 100, 'Y', NULL), 'N', 'Y') AUTHORIZED_FLAG, NVL(SEFT.SETTLE_REQUIRE_VRFY_FLAG, 'N') SETTLE_REQ_AUTH_FLAG FROM IBY_TRXN_SUMMARIES_ALL SUMM, IBY_FNDCPT_TX_OPERATIONS OP, IBY_FNDCPT_SYS_EFT_PF_B SEFT, IBY_FNDCPT_USER_EFT_PF_B UEFT WHERE(SUMM.TRANSACTIONID = OP.TRANSACTIONID) AND(REQTYPE = 'ORAPMTREQ') AND(TRXNTYPEID IN(2, 3, 20)) AND(DECODE(INSTRTYPE, 'BANKACCOUNT', SUMM.PROCESS_PROFILE_CODE, NULL) = UEFT.USER_EFT_PROFILE_CODE(+)) AND(UEFT.SYS_EFT_PROFILE_CODE = SEFT.SYS_EFT_PROFILE_CODE(+))) AUTH, FND_APPLICATION A WHERE EXT.TRXN_EXTENSION_ID = IL.PAYMENT_TRXN_EXTENSION_ID AND EXT.TRXN_EXTENSION_ID = AUTH.TRXN_EXTENSION_ID(+) AND AUTH.SETTLE_REQ_AUTH_FLAG(+) = 'Y' AND EXT.ORIGIN_APPLICATION_ID = A.APPLICATION_ID GROUP BY AUTH.AUTHORIZED_FLAG, EXT.INSTR_ASSIGNMENT_ID, EXT.TRXN_EXTENSION_ID) WHERE REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID AND PAYMENT_TRXN_EXTENSION_ID IS NOT NULL
|
| cd9mbmqyf4qhp | UPDATE WF_ITEM_ACTIVITY_STATUSES SET ACTIVITY_STATUS = :B8 , ACTIVITY_RESULT_CODE = NVL(:B13 , ACTIVITY_RESULT_CODE), BEGIN_DATE = NVL(:B11 , BEGIN_DATE), END_DATE = NVL(:B12 , END_DATE), DUE_DATE = DECODE(:B11 , TO_DATE(NULL), DUE_DATE, :B10 ), OUTBOUND_QUEUE_ID = :B9 , EXECUTION_TIME = DECODE(:B8 , :B7 , :B4 , :B6 , NVL(EXECUTION_TIME, :B4 ), :B5 , NVL(EXECUTION_TIME, :B4 ), EXECUTION_TIME) WHERE ITEM_TYPE = :B3 AND ITEM_KEY = :B2 AND PROCESS_ACTIVITY = :B1 |
| cw171rvngr1w9 | begin OE_FLEX_COGS_PUB.GET_COST_SALE_ITEM_DERIVED (:v1, :v2, :v3, :v4, :v5); end; |
| dcvv68fju01g4 | begin FND_FLEX_WORKFLOW_APIS.END_GENERATION (:v1, :v2, :v3, :v4, :v5); end; |
| f07y7y34utqz1 | SELECT SEQUENCE_NUMBER FROM WSH_DOCUMENT_INSTANCES WHERE ENTITY_NAME = :B3 AND ENTITY_ID = :B2 AND STATUS <> 'CANCELLED' AND DOCUMENT_TYPE = :B1 |
| g2qs4xk48vcwy | select to_char(CODE_COMBINATION_ID), nvl(ENABLED_FLAG, 'Y'), nvl(SUMMARY_FLAG, 'N'), to_char(START_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), to_char(END_DATE_ACTIVE, 'YYYY/MM/DD HH24:MI:SS'), SEGMENT1, SEGMENT2, SEGMENT3, SEGMENT4, SEGMENT5, DETAIL_BUDGETING_ALLOWED_FLAG, DETAIL_POSTING_ALLOWED_FLAG, ACCOUNT_TYPE, REFERENCE3, JGZZ_RECON_FLAG from GL_CODE_COMBINATIONS where CHART_OF_ACCOUNTS_ID = :FND_BIND1 and (SEGMENT1 = :FND_BIND2) and (SEGMENT2 = :FND_BIND3) and (SEGMENT3 = :FND_BIND4) and (SEGMENT4 = :FND_BIND5) and (SEGMENT5 = :FND_BIND6) |
| gnhmcahkmrnzs | INSERT INTO WF_ITEM_ACTIVITY_STATUSES ( ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY, ACTIVITY_STATUS, ACTIVITY_RESULT_CODE, ASSIGNED_USER, NOTIFICATION_ID, BEGIN_DATE, END_DATE, DUE_DATE, EXECUTION_TIME, OUTBOUND_QUEUE_ID ) VALUES ( :B13 , :B12 , :B11 , :B6 , :B10 , NULL, NULL, :B9 , :B8 , :B7 , DECODE(:B6 , :B5 , :B2 , :B4 , :B2 , :B3 , :B2 , NULL), :B1 ) |