| SQL Id | SQL Text |
|---|
| 089dbukv1aanh | SELECT SYS_EXTRACT_UTC(SYSTIMESTAMP) FROM DUAL |
| 08bqjmf8490s2 | SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1 |
| 08vznc16ycuag | SELECT SYS_GUID() FROM SYS.DUAL |
| 09x9kbx1q4qky |
INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP ( TRANSACTION_HEADER_ID , TRANSACTION_TEMP_ID , SOURCE_CODE , SOURCE_LINE_ID , TRANSACTION_MODE , LOCK_FLAG , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , INVENTORY_ITEM_ID , REVISION , ORGANIZATION_ID , SUBINVENTORY_CODE , LOCATOR_ID , TRANSACTION_QUANTITY , PRIMARY_QUANTITY , SECONDARY_TRANSACTION_QUANTITY , TRANSACTION_UOM , SECONDARY_UOM_CODE , TRANSACTION_COST , TRANSACTION_TYPE_ID , TRANSACTION_ACTION_ID , TRANSACTION_SOURCE_TYPE_ID , TRANSACTION_SOURCE_ID , TRANSACTION_SOURCE_NAME , TRANSACTION_DATE , ACCT_PERIOD_ID , DISTRIBUTION_ACCOUNT_ID , TRANSACTION_REFERENCE , REQUISITION_LINE_ID , REQUISITION_DISTRIBUTION_ID , REASON_ID , LOT_NUMBER , LOT_EXPIRATION_DATE , SERIAL_NUMBER , RECEIVING_DOCUMENT , DEMAND_ID , RCV_TRANSACTION_ID , MOVE_TRANSACTION_ID , COMPLETION_TRANSACTION_ID , WIP_ENTITY_TYPE , SCHEDULE_ID , REPETITIVE_LINE_ID , EMPLOYEE_CODE , PRIMARY_SWITCH , SCHEDULE_UPDATE_CODE , SETUP_TEARDOWN_CODE , ITEM_ORDERING , NEGATIVE_REQ_FLAG , OPERATION_SEQ_NUM , PICKING_LINE_ID , TRX_SOURCE_LINE_ID , TRX_SOURCE_DELIVERY_ID , PHYSICAL_ADJUSTMENT_ID , CYCLE_COUNT_ID , RMA_LINE_ID , CUSTOMER_SHIP_ID , CURRENCY_CODE , CURRENCY_CONVERSION_RATE , CURRENCY_CONVERSION_TYPE , CURRENCY_CONVERSION_DATE , USSGL_TRANSACTION_CODE , VENDOR_LOT_NUMBER , ENCUMBRANCE_ACCOUNT , ENCUMBRANCE_AMOUNT , SHIP_TO_LOCATION , SHIPMENT_NUMBER , TRANSFER_COST , TRANSPORTATION_COST , TRANSPORTATION_ACCOUNT , FREIGHT_CODE , CONTAINERS , WAYBILL_AIRBILL , EXPECTED_ARRIVAL_DATE , TRANSFER_SUBINVENTORY , TRANSFER_ORGANIZATION , TRANSFER_TO_LOCATION , NEW_AVERAGE_COST , VALUE_CHANGE , PERCENTAGE_CHANGE , MATERIAL_ALLOCATION_TEMP_ID , DEMAND_SOURCE_HEADER_ID , DEMAND_SOURCE_LINE , DEMAND_SOURCE_DELIVERY , ITEM_SEGMENTS , ITEM_DESCRIPTION , ITEM_TRX_ENABLED_FLAG , ITEM_LOCATION_CONTROL_CODE , ITEM_RESTRICT_SUBINV_CODE , ITEM_RESTRICT_LOCATORS_CODE , ITEM_REVISION_QTY_CONTROL_CODE , ITEM_PRIMARY_UOM_CODE , ITEM_UOM_CLASS , ITEM_SHELF_LIFE_CODE , ITEM_SHELF_LIFE_DAYS , ITEM_LOT_CONTROL_CODE , ITEM_SERIAL_CONTROL_CODE , ITEM_INVENTORY_ASSET_FLAG , ALLOWED_UNITS_LOOKUP_CODE , DEPARTMENT_ID , DEPARTMENT_CODE , WIP_SUPPLY_TYPE , SUPPLY_SUBINVENTORY , SUPPLY_LOCATOR_ID , VALID_SUBINVENTORY_FLAG , VALID_LOCATOR_FLAG , LOCATOR_SEGMENTS , CURRENT_LOCATOR_CONTROL_CODE , NUMBER_OF_LOTS_ENTERED , WIP_COMMIT_FLAG , NEXT_LOT_NUMBER , LOT_ALPHA_PREFIX , NEXT_SERIAL_NUMBER , SERIAL_ALPHA_PREFIX , SHIPPABLE_FLAG , POSTING_FLAG , REQUIRED_FLAG , PROCESS_FLAG , ERROR_CODE , ERROR_EXPLANATION , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , MOVEMENT_ID , RESERVATION_QUANTITY , SHIPPED_QUANTITY , TRANSACTION_LINE_NUMBER , TASK_ID , TO_TASK_ID , SOURCE_TASK_ID , PROJECT_ID , SOURCE_PROJECT_ID , PA_EXPENDITURE_ORG_ID , TO_PROJECT_ID , EXPENDITURE_TYPE , FINAL_COMPLETION_FLAG , TRANSFER_PERCENTAGE , TRANSACTION_SEQUENCE_ID , MATERIAL_ACCOUNT , MATERIAL_OVERHEAD_ACCOUNT , RESOURCE_ACCOUNT , OUTSIDE_PROCESSING_ACCOUNT , OVERHEAD_ACCOUNT , FLOW_SCHEDULE , COST_GROUP_ID , DEMAND_CLASS , QA_COLLECTION_ID , KANBAN_CARD_ID , OVERCOMPLETION_TRANSACTION_ID , OVERCOMPLETION_PRIMARY_QTY , OVERCOMPLETION_TRANSACTION_QTY , END_ITEM_UNIT_NUMBER , SCHEDULED_PAYBACK_DATE , LINE_TYPE_CODE , PARENT_TRANSACTION_TEMP_ID , PUT_AWAY_STRATEGY_ID , PUT_AWAY_RULE_ID , PICK_STRATEGY_ID , PICK_RULE_ID , COMMON_BOM_SEQ_ID , COMMON_ROUTING_SEQ_ID , COST_TYPE_ID , ORG_COST_GROUP_ID , MOVE_ORDER_LINE_ID , TASK_GROUP_ID , PICK_SLIP_NUMBER , RESERVATION_ID , TRANSACTION_STATUS , TRANSFER_COST_GROUP_ID
, LPN_ID , WMS_TASK_TYPE , ALLOCATED_LPN_ID , MOVE_ORDER_HEADER_ID , SERIAL_ALLOCATED_FLAG , WMS_TASK_STATUS , TASK_PRIORITY ) VALUES ( :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B193 , :B192 , :B193 , :B192 , :B191 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :B22 , :B23 , :B24 , :B25 , :B26 , :B27 , :B28 , :B29 , :B30 , :B31 , :B32 , :B33 , :B34 , :B35 , :B36 , :B37 , :B38 , :B39 , :B40 , :B41 , :B42 , :B43 , :B44 , :B45 , :B46 , :B47 , :B48 , :B49 , :B50 , :B51 , :B52 , :B53 , :B54 , :B55 , :B56 , :B57 , :B58 , :B59 , :B60 , :B61 , :B62 , :B63 , :B64 , :B65 , :B66 , :B67 , :B68 , :B69 , :B70 , :B71 , :B72 , :B73 , :B74 , :B75 , :B76 , :B77 , :B78 , :B79 , :B80 , :B81 , :B82 , :B83 , :B84 , :B85 , :B86 , :B87 , :B88 , :B89 , :B90 , :B91 , :B92 , :B93 , :B94 , :B95 , :B96 , :B97 , :B98 , :B99 , :B100 , :B101 , :B102 , :B103 , :B104 , :B105 , :B106 , :B107 , :B108 , :B109 , :B110 , :B111 , :B112 , :B113 , :B114 , :B115 , :B116 , :B117 , :B118 , :B119 , :B120 , :B121 , :B122 , :B123 , :B124 , :B125 , :B126 , :B127 , :B128 , :B129 , :B130 , :B131 , :B132 , :B133 , :B134 , :B135 , :B136 , :B137 , :B138 , :B139 , :B140 , :B141 , :B142 , :B143 , :B144 , :B145 , :B146 , :B147 , :B148 , :B149 , :B150 , :B151 , :B152 , :B153 , :B154 , :B155 , :B156 , :B157 , :B158 , :B159 , :B160 , :B161 , :B162 , :B163 , :B164 , :B165 , :B166 , :B167 , :B168 , :B169 , :B170 , :B171 , :B172 , :B173 , :B174 , :B175 , :B176 , :B177 , :B178 , :B179 , :B180 , :B181 , :B182 , :B183 , :B184 , :B185 , :B186 , :B187 , :B188 , :B189 , :B190 ) |
| 0aqjpk56w9cgw | SELECT LINE_ID FROM OE_ORDER_LINES WHERE LINE_ID = :B1 FOR UPDATE NOWAIT |
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0puu35brrk8z4 | SELECT * FROM MTL_SYSTEM_ITEMS WHERE ORGANIZATION_ID = :B2 AND INVENTORY_ITEM_ID = :B1 |
| 0q8w0cndsp865 | SELECT FPOV.PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES FPOV, FND_PROFILE_OPTIONS FPO WHERE FPO.PROFILE_OPTION_NAME = 'AFCORE_LOGGING_ENABLED' AND FPO.PROFILE_OPTION_ID = FPOV.PROFILE_OPTION_ID AND FPOV.LEVEL_ID = 10001 AND FPO.APPLICATION_ID = FPOV.APPLICATION_ID |
| 0rmc1181qy4mc | select q_name, state, delay, expiration, rowid, msgid, dequeue_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no, priority, exception_qschema, exception_queue, retry_count, corrid, time_manager_info, sender_name, sender_address, sender_protocol from "XNP"."XNP_IN_EVT_QTAB" where time_manager_info <= :1 and state <> :2 for update skip locked |
| 0rxhfv39us09g | SELECT 'Y' FROM RA_CUSTOMER_TRX_LINES CTL WHERE CTL.CUSTOMER_TRX_ID = :B1 AND CTL.LINE_TYPE = 'LINE' AND NVL(CTL.AUTORULE_COMPLETE_FLAG, 'Y') <> 'N' |
| 0wmwsjy9kd92f | SELECT PROFILE_OPTION_ID, APPLICATION_ID, SITE_ENABLED_FLAG , APP_ENABLED_FLAG , RESP_ENABLED_FLAG , USER_ENABLED_FLAG, ORG_ENABLED_FLAG , SERVER_ENABLED_FLAG, SERVERRESP_ENABLED_FLAG, HIERARCHY_TYPE, USER_CHANGEABLE_FLAG FROM FND_PROFILE_OPTIONS WHERE PROFILE_OPTION_NAME = :B1 AND START_DATE_ACTIVE <= SYSDATE AND NVL(END_DATE_ACTIVE, SYSDATE) >= SYSDATE |
| 19x1189chq3xd | SELECT LOCKID FROM DBMS_LOCK_ALLOCATED WHERE NAME = :B1 FOR UPDATE |
| 1gu8t96d0bdmu | select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) |
| 23ysj88h2xpmf | SELECT TT.NAME FROM OE_TRANSACTION_TYPES_TL TT, OE_ORDER_HEADERS OH WHERE TT.LANGUAGE = ( SELECT LANGUAGE_CODE FROM FND_LANGUAGES WHERE INSTALLED_FLAG = 'B') AND TT.TRANSACTION_TYPE_ID = OH.ORDER_TYPE_ID AND OH.HEADER_ID = :B1 |
| 2dyqu5d5yx40z | insert into RA_INTERFACE_ERRORS (INTERFACE_LINE_ID, MESSAGE_TEXT, INVALID_VALUE, ORG_ID)select L.INTERFACE_LINE_ID , :b0 , L.CURRENCY_CODE , L.ORG_ID from RA_INTERFACE_LINES_GT L , AR_RECEIPT_CLASSES RC , AR_RECEIPT_METHODS RM where ((((((((L.REQUEST_ID=:b1 and L.CUSTOMER_TRX_ID is not null ) and NVL(L.INTERFACE_STATUS, :"SYS_B_0")<>:"SYS_B_1") and L.RECEIPT_METHOD_ID is not null ) and L.RECEIPT_METHOD_ID=RM.RECEIPT_METHOD_ID) and RM.RECEIPT_CLASS_ID=RC.RECEIPT_CLASS_ID) and RC.CREATION_METHOD_CODE in (:"SYS_B_2", :"SYS_B_3", :"SYS_B_4")) and not exists (select :"SYS_B_5" from AR_RECEIPT_METHOD_ACCOUNTS A , CE_BANK_ACCOUNTS CBA , CE_BANK_ACCT_USES B where (((L.RECEIPT_METHOD_ID=A.RECEIPT_METHOD_ID and A.REMIT_BANK_ACCT_USE_ID=B.BANK_ACCT_USE_ID) and B.BANK_ACCOUNT_ID=CBA.BANK_ACCOUNT_ID) and DECODE(CBA.RECEIPT_MULTI_CURRENCY_FLAG, :"SYS_B_6", L.CURRENCY_CODE, CBA.CURRENCY_CODE)=L.CURRENCY_CODE))) and not exists (select :"SYS_B_7" from AR_RECEIPT_METHODS RM , AR_RECEIPT_CLASSES RC where ((L.RECEIPT_METHOD_ID=RM.RECEIPT_METHOD_ID and RM.RECEIPT_CLASS_ID=RC.RECEIPT_CLASS_ID) and RC.CREATION_METHOD_CODE=:"SYS_B_8"))) |
| 2v1vanmps8nck | SELECT NVL(OT.CUST_TRX_TYPE_ID, 0) FROM OE_ORDER_TYPES_V OT, OE_ORDER_HEADERS_ALL OH WHERE OT.ORDER_TYPE_ID = OH.ORDER_TYPE_ID AND OH.HEADER_ID = :B1 |
| 2x6mz7m4dd7xr |
INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID, REC_OFFSET_FLAG, ORG_ID ) SELECT LINES.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_ID, PSUM.CODE_COMBINATION_ID, :B8 , PSUM.ACCOUNT_CLASS, 'N', ROUND((DECODE(PSUM.ACCOUNT_CLASS, 'SUSPENSE', (LINES.EXTENDED_AMOUNT - LINES.REVENUE_AMOUNT), DECODE(LINES.REVENUE_AMOUNT, 0, 1, LINES.REVENUE_AMOUNT)) / DECODE(PSUM.ACCOUNT_CLASS, 'SUSPENSE', DECODE((LINES.EXTENDED_AMOUNT - LINES.REVENUE_AMOUNT), 0, 1, (LINES.EXTENDED_AMOUNT - LINES.REVENUE_AMOUNT)), DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) ) * PSUM.PERCENT, 4 ), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( ((PSUM.PERCENT / 100) * DECODE(PSUM.ACCOUNT_CLASS, 'SUSPENSE', (LINES.EXTENDED_AMOUNT - LINES.REVENUE_AMOUNT), LINES.REVENUE_AMOUNT)), FC.PRECISION), ROUND( ((PSUM.PERCENT / 100) * DECODE(PSUM.ACCOUNT_CLASS, 'SUSPENSE', (LINES.EXTENDED_AMOUNT - LINES.REVENUE_AMOUNT), LINES.REVENUE_AMOUNT)) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), DECODE(:B6 , NULL, ROUND( NVL(TRX.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( ((PSUM.PERCENT / 100) * DECODE(PSUM.ACCOUNT_CLASS, 'SUSPENSE', (LINES.EXTENDED_AMOUNT - LINES.REVENUE_AMOUNT), LINES.REVENUE_AMOUNT)), FC.PRECISION), ROUND( ((PSUM.PERCENT / 100) * DECODE(PSUM.ACCOUNT_CLASS, 'SUSPENSE', (LINES.EXTENDED_AMOUNT - LINES.REVENUE_AMOUNT), LINES.REVENUE_AMOUNT)) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), :B7 ), ROUND( ( NVL(TRX.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( ((PSUM.PERCENT / 100) * DECODE(PSUM.ACCOUNT_CLASS, 'SUSPENSE', (LINES.EXTENDED_AMOUNT - LINES.REVENUE_AMOUNT), LINES.REVENUE_AMOUNT)), FC.PRECISION), ROUND( ((PSUM.PERCENT / 100) * DECODE(PSUM.ACCOUNT_CLASS, 'SUSPENSE', (LINES.EXTENDED_AMOUNT - LINES.REVENUE_AMOUNT), LINES.REVENUE_AMOUNT)) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT)) / :B6 ) * :B6 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_REC(REC.GL_DATE) ), DECODE(PSUM.CUSTOMER_TRX_ID, TRX.CUSTOMER_TRX_ID, PSUM.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B5 , :B4 , SYSDATE, :B4 , SYSDATE, :B3 , :B2 , SYSDATE, -3, NVL( NVL(REC.ORIGINAL_GL_DATE, REC.GL_DATE), TRX.TRX_DATE), RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL, DECODE(PSUM.ACCOUNT_CLASS, 'UNEARN', 'Y', 'UNBILL', 'Y', NULL) , TRX.ORG_ID FROM RA_CUSTOMER_TRX_LINES PSUM_LINES, RA_CUSTOMER_TRX PSUM_TRX, RA_CUST_TRX_LINE_GL_DIST PSUM, RA_CUST_TRX_LINE_SALESREPS CMSREP, RA_CUSTOMER_TRX_LINES LINES, RA_CUST_TRX_LINE_GL_DIST REC, FND_CURRENCIES FC, RA_CUSTOMER_TRX TRX WHERE TRX.CUSTOMER_TRX_ID = :B1 AND TRX.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = TRX.INVOICE_CURRENCY_CODE AND REC.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND REC.CUSTOMER_TRX_LINE_ID IS NULL AND LINES.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND PSUM_TRX.CUSTOMER_TRX_ID = PSUM.CUSTOMER_TRX_ID AND PSUM_LINES.CUSTOMER_TRX_LINE_ID = PSUM.CUSTOMER_TRX_LINE_ID AND PSUM.ACCOUNT_CLASS IN ( 'SUSPENSE'|| DECODE(LINES.EXTENDED_AMOUNT - NVL(LINES.REVENUE_AMOUNT, 0), 0, 'X', NULL), DECODE(TRX.INVOICING_RULE_ID, -2, 'UNEARN', -3, 'UNBILL') ) AND PSUM.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' A
ND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND CMSREP.PREV_CUST_TRX_LINE_SALESREP_ID (+) = PSUM.CUST_TRX_LINE_SALESREP_ID AND CMSREP.CUSTOMER_TRX_ID (+) = :B1 AND LINES.CUSTOMER_TRX_LINE_ID = DECODE(LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, LINES.CUSTOMER_TRX_LINE_ID, NVL(CMSREP.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID)) AND PSUM.ACCOUNT_SET_FLAG = 'Y' AND NOT EXISTS ( SELECT 'plug sum account exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE SUBDIST.ACCOUNT_CLASS IN ( 'SUSPENSE', DECODE(TRX.INVOICING_RULE_ID, -2, 'UNEARN', -3, 'UNBILL') ) AND SUBDIST.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.REC_OFFSET_FLAG = 'Y') |
| 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_UPDATE_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, SOURCE_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)) |
| 3dmv51agpx0sx | SELECT NVL(LT.INVOICE_SOURCE_ID, OT.INVOICE_SOURCE_ID) FROM OE_LINE_TYPES_V LT, OE_ORDER_TYPES_V OT, OE_ORDER_HEADERS_ALL OH WHERE LT.LINE_TYPE_ID = :B2 AND OT.ORDER_TYPE_ID = OH.ORDER_TYPE_ID AND OH.HEADER_ID = :B1 |
| 3ktacv9r56b51 | select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# |
| 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 |
| 3xunnvn4a302n |
INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID, ORG_ID ) SELECT /*+ ORDERED */ ASS.CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_ID, DIST.CODE_COMBINATION_ID, :B12 , ASS.ACCOUNT_CLASS, 'N', ROUND( (DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1 ), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1 ) ), ASS.AMOUNT ), FC.PRECISION), ROUND( ((DIST.PERCENT/100) * DECODE(ASS.AMOUNT, 0, DECODE(ASS.ACCOUNT_CLASS, 'REV', DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, 1, -1), DECODE( LINES.PREVIOUS_CUSTOMER_TRX_ID, NULL, -1, 1) ), ASS.AMOUNT) ) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT) / DECODE(LINES.EXTENDED_AMOUNT, 0, 1, LINES.EXTENDED_AMOUNT)) * DECODE(ASS.AMOUNT, 0, 0, 100), 4), DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B10 , NULL, ROUND( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ((DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ), :B11 ), ROUND( ( NVL(HEADER.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( (DIST.PERCENT/100) * ASS.AMOUNT, FC.PRECISION), ROUND( ( (DIST.PERCENT/100) * ASS.AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT ) ) / :B10 ) * :B10 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_DATE(ASS.GL_DATE) ), DECODE(DIST.CUSTOMER_TRX_ID, HEADER.CUSTOMER_TRX_ID, DIST.CUST_TRX_LINE_SALESREP_ID, CMSREP.CUST_TRX_LINE_SALESREP_ID), :B9 , :B8 , :B7 , SYSDATE, SYSDATE, :B6 , SYSDATE, :B6 , -3, ASS.GL_DATE, RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL, HEADER.ORG_ID FROM RA_CUSTOMER_TRX HEADER, FND_CURRENCIES FC, RA_CUSTOMER_TRX_LINES LINES, RA_RULES ACC_RULE, RA_CUST_TRX_LINE_GL_DIST REC, RA_CUST_TRX_LINE_GL_DIST DIST, RA_CUST_TRX_LINE_SALESREPS CMSREP, AR_REV_ASSIGN_FOR_STD_V ASS WHERE HEADER.CUSTOMER_TRX_ID = :B1 AND ASS.CUSTOMER_TRX_ID = :B1 AND HEADER.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = HEADER.INVOICE_CURRENCY_CODE AND LINES.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND LINES.AUTORULE_COMPLETE_FLAG||'' = 'N' AND ASS.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND ASS.PERIOD_SET_NAME = :B5 AND ACC_RULE.RULE_ID = LINES.ACCOUNTING_RULE_ID AND ACC_RULE.TYPE IN ('A', 'ACC_DUR') AND DECODE(HEADER.INVOICING_RULE_ID, -3, :B3 , DECODE(NVL(ACC_RULE.DEFERRED_REVENUE_FLAG, 'N'), 'Y', :B2 , DECODE(:B4 , 'N', :B3 , DECODE(HEADER.PREVIOUS_CUSTOMER_TRX_ID, NULL, AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBILITY(:B1 , LINES.CUSTOMER_TRX_LINE_ID), AR_REVENUE_MANAGEMENT_PVT.LINE_COLLECTIBLE( LINES.PREVIOUS_CUSTOMER_TRX_ID, LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID))))) <> :B2 AND REC.CUSTOMER_TRX_ID = HEADER.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND DIST.CUSTOMER_TRX_LINE_ID = (SELECT DECODE(COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(LINES.PREVIOUS_CUSTOMER_TRX_LINE_ID, LINES.CUSTOMER_TRX_LINE_ID), LINES.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID = LINES.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND DIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND DIST.ACCOUNT_SET_FLAG = 'Y' AND DIST.CUST_TRX_LINE_SALESREP_ID = CMSREP.PREV_C
UST_TRX_LINE_SALESREP_ID (+) AND :B1 = CMSREP.CUSTOMER_TRX_ID (+) AND NOT EXISTS ( SELECT 'distribution exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE SUBDIST.CUSTOMER_TRX_LINE_ID = ASS.CUSTOMER_TRX_LINE_ID AND SUBDIST.CUSTOMER_TRX_ID + 0 = LINES.CUSTOMER_TRX_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.ACCOUNT_CLASS = ASS.ACCOUNT_CLASS AND SUBDIST.ORIGINAL_GL_DATE = ASS.GL_DATE ) |
| 50thu59cud6yu | SELECT NVL(M.COST_OF_SALES_ACCOUNT, 0) FROM OE_ORDER_LINES OL, MTL_SYSTEM_ITEMS M WHERE OL.LINE_ID = :B1 AND M.ORGANIZATION_ID = OL.SHIP_FROM_ORG_ID AND M.INVENTORY_ITEM_ID = OL.INVENTORY_ITEM_ID |
| 55dc767ajydh3 | SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = 10003 AND LEVEL_VALUE = :B2 AND LEVEL_VALUE_APPLICATION_ID = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL |
| 5af1f003zv7st |
INSERT INTO CSI_ITEM_INSTANCES_H( INSTANCE_HISTORY_ID, INSTANCE_ID, TRANSACTION_ID, OLD_INSTANCE_NUMBER, NEW_INSTANCE_NUMBER, OLD_EXTERNAL_REFERENCE, NEW_EXTERNAL_REFERENCE, OLD_INVENTORY_ITEM_ID, NEW_INVENTORY_ITEM_ID, OLD_INVENTORY_REVISION, NEW_INVENTORY_REVISION, OLD_INV_MASTER_ORGANIZATION_ID, NEW_INV_MASTER_ORGANIZATION_ID, OLD_SERIAL_NUMBER, NEW_SERIAL_NUMBER , OLD_MFG_SERIAL_NUMBER_FLAG, NEW_MFG_SERIAL_NUMBER_FLAG, OLD_LOT_NUMBER, NEW_LOT_NUMBER, OLD_QUANTITY, NEW_QUANTITY, OLD_UNIT_OF_MEASURE, NEW_UNIT_OF_MEASURE, OLD_ACCOUNTING_CLASS_CODE, NEW_ACCOUNTING_CLASS_CODE, OLD_INSTANCE_CONDITION_ID, NEW_INSTANCE_CONDITION_ID, OLD_INSTANCE_STATUS_ID, NEW_INSTANCE_STATUS_ID, OLD_CUSTOMER_VIEW_FLAG, NEW_CUSTOMER_VIEW_FLAG, OLD_MERCHANT_VIEW_FLAG, NEW_MERCHANT_VIEW_FLAG, OLD_SELLABLE_FLAG, NEW_SELLABLE_FLAG, OLD_SYSTEM_ID, NEW_SYSTEM_ID, OLD_INSTANCE_TYPE_CODE, NEW_INSTANCE_TYPE_CODE, OLD_ACTIVE_START_DATE, NEW_ACTIVE_START_DATE, OLD_ACTIVE_END_DATE, NEW_ACTIVE_END_DATE, OLD_LOCATION_TYPE_CODE, NEW_LOCATION_TYPE_CODE, OLD_LOCATION_ID, NEW_LOCATION_ID, OLD_INV_ORGANIZATION_ID, NEW_INV_ORGANIZATION_ID, OLD_INV_SUBINVENTORY_NAME, NEW_INV_SUBINVENTORY_NAME, OLD_INV_LOCATOR_ID, NEW_INV_LOCATOR_ID, OLD_PA_PROJECT_ID, NEW_PA_PROJECT_ID, OLD_PA_PROJECT_TASK_ID, NEW_PA_PROJECT_TASK_ID, OLD_IN_TRANSIT_ORDER_LINE_ID, NEW_IN_TRANSIT_ORDER_LINE_ID, OLD_WIP_JOB_ID, NEW_WIP_JOB_ID, OLD_PO_ORDER_LINE_ID, NEW_PO_ORDER_LINE_ID, OLD_COMPLETENESS_FLAG, NEW_COMPLETENESS_FLAG, FULL_DUMP_FLAG, OLD_CONTEXT, NEW_CONTEXT, OLD_ATTRIBUTE1, NEW_ATTRIBUTE1, OLD_ATTRIBUTE2, NEW_ATTRIBUTE2, OLD_ATTRIBUTE3, NEW_ATTRIBUTE3, OLD_ATTRIBUTE4, NEW_ATTRIBUTE4, OLD_ATTRIBUTE5, NEW_ATTRIBUTE5, OLD_ATTRIBUTE6, NEW_ATTRIBUTE6, OLD_ATTRIBUTE7, NEW_ATTRIBUTE7, OLD_ATTRIBUTE8, NEW_ATTRIBUTE8, OLD_ATTRIBUTE9, NEW_ATTRIBUTE9, OLD_ATTRIBUTE10, NEW_ATTRIBUTE10, OLD_ATTRIBUTE11, NEW_ATTRIBUTE11, OLD_ATTRIBUTE12, NEW_ATTRIBUTE12, OLD_ATTRIBUTE13, NEW_ATTRIBUTE13, OLD_ATTRIBUTE14, NEW_ATTRIBUTE14, OLD_ATTRIBUTE15, NEW_ATTRIBUTE15, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, OLD_INST_LOC_TYPE_CODE, NEW_INST_LOC_TYPE_CODE, OLD_INST_LOC_ID, NEW_INST_LOC_ID, OLD_INST_USAGE_CODE, NEW_INST_USAGE_CODE, OLD_LAST_VLD_ORGANIZATION_ID, NEW_LAST_VLD_ORGANIZATION_ID, OLD_CONFIG_INST_REV_NUM , NEW_CONFIG_INST_REV_NUM , OLD_CONFIG_VALID_STATUS , NEW_CONFIG_VALID_STATUS , OLD_INSTANCE_DESCRIPTION , NEW_INSTANCE_DESCRIPTION , OLD_INSTALL_DATE , NEW_INSTALL_DATE , OLD_RETURN_BY_DATE , NEW_RETURN_BY_DATE , OLD_ACTUAL_RETURN_DATE , NEW_ACTUAL_RETURN_DATE , OLD_OE_AGREEMENT_ID , NEW_OE_AGREEMENT_ID , OLD_LAST_OE_ORDER_LINE_ID, NEW_LAST_OE_ORDER_LINE_ID, OLD_LAST_OE_RMA_LINE_ID, NEW_LAST_OE_RMA_LINE_ID, OLD_LAST_WIP_JOB_ID, NEW_LAST_WIP_JOB_ID, OLD_LAST_PO_PO_LINE_ID, NEW_LAST_PO_PO_LINE_ID, OLD_LAST_PA_PROJECT_ID, NEW_LAST_PA_PROJECT_ID, OLD_LAST_PA_TASK_ID, NEW_LAST_PA_TASK_ID, OLD_LAST_TXN_LINE_DETAIL_ID, NEW_LAST_TXN_LINE_DETAIL_ID, OLD_LAST_OE_PO_NUMBER, NEW_LAST_OE_PO_NUMBER, OLD_NETWORK_ASSET_FLAG, NEW_NETWORK_ASSET_FLAG, OLD_MAINTAINABLE_FLAG, NEW_MAINTAINABLE_FLAG, OLD_PN_LOCATION_ID, NEW_PN_LOCATION_ID, OLD_ASSET_CRITICALITY_CODE, NEW_ASSET_CRITICALITY_CODE, OLD_CATEGORY_ID, NEW_CATEGORY_ID, OLD_EQUIPMENT_GEN_OBJECT_ID, NEW_EQUIPMENT_GEN_OBJECT_ID, OLD_INSTANTIATION_FLAG, NEW_INSTANTIATION_FLAG, OLD_LINEAR_LOCATION_ID, NEW_LINEAR_LOCATION_ID, OLD_OPERATIONAL_LOG_FLAG, NEW_OPERATIONAL_LOG_FLAG, OLD_CHECKIN_STATUS, NEW_CHECKIN_STATUS, OLD_SUPPLIER_WARRANTY_EXP_DATE, NEW_SUPPLIER_WARRANTY_EXP_DATE, OLD_ATTRIBUTE16, NEW_ATTRIBUTE16, OLD_ATTRIBUTE17, NEW_ATTRIBUTE17, OLD_ATTRIBUTE18, NEW_ATTRIBUTE18, OLD_ATTRIBUTE19, NEW_ATTRIBUTE19, OLD_ATTRIBUTE20, NEW_ATTRIBUTE20, OLD_ATTRIBUTE21, NEW_ATTRIBUTE21, OLD_ATTRIBUTE22, NEW_ATTRIBUTE22, OLD_ATTRIBUTE23, NEW_ATTRIBU
TE23, OLD_ATTRIBUTE24, NEW_ATTRIBUTE24, OLD_ATTRIBUTE25, NEW_ATTRIBUTE25, OLD_ATTRIBUTE26, NEW_ATTRIBUTE26, OLD_ATTRIBUTE27, NEW_ATTRIBUTE27, OLD_ATTRIBUTE28, NEW_ATTRIBUTE28, OLD_ATTRIBUTE29, NEW_ATTRIBUTE29, OLD_ATTRIBUTE30, NEW_ATTRIBUTE30, OLD_PAYABLES_UNIT_PRICE, NEW_PAYABLES_UNIT_PRICE, OLD_PAYABLES_CURRENCY_CODE, NEW_PAYABLES_CURRENCY_CODE, OLD_PURCHASE_UNIT_PRICE, NEW_PURCHASE_UNIT_PRICE, OLD_PURCHASE_CURRENCY_CODE, NEW_PURCHASE_CURRENCY_CODE, OLD_SALES_UNIT_PRICE, NEW_SALES_UNIT_PRICE, OLD_SALES_CURRENCY_CODE, NEW_SALES_CURRENCY_CODE, OLD_OPERATIONAL_STATUS_CODE, NEW_OPERATIONAL_STATUS_CODE, OLD_SOURCE_CODE, NEW_SOURCE_CODE ) VALUES ( :B213 , DECODE( :B212 , :B9 , NULL, :B212 ), DECODE( :B211 , :B9 , NULL, :B211 ), DECODE( :B210 , :B2 , NULL, :B210 ), DECODE( :B209 , :B2 , NULL, :B209 ), DECODE( :B208 , :B2 , NULL, :B208 ), DECODE( :B207 , :B2 , NULL, :B207 ), DECODE( :B206 , :B9 , NULL, :B206 ), DECODE( :B205 , :B9 , NULL, :B205 ), DECODE( :B204 , :B2 , NULL, :B204 ), DECODE( :B203 , :B2 , NULL, :B203 ), DECODE( :B202 , :B9 , NULL, :B202 ), DECODE( :B201 , :B9 , NULL, :B201 ), DECODE( :B200 , :B2 , NULL, :B200 ), DECODE( :B199 , :B2 , NULL, :B199 ) , DECODE( :B198 , :B2 , NULL, :B198 ), DECODE( :B197 , :B2 , NULL, :B197 ), DECODE( :B196 , :B2 , NULL, :B196 ), DECODE( :B195 , :B2 , NULL, :B195 ), DECODE( :B194 , :B9 , NULL, :B194 ), DECODE( :B193 , :B9 , NULL, :B193 ), DECODE( :B192 , :B2 , NULL, :B192 ), DECODE( :B191 , :B2 , NULL, :B191 ), DECODE( :B190 , :B2 , NULL, :B190 ), DECODE( :B189 , :B2 , NULL, :B189 ), DECODE( :B188 , :B9 , NULL, :B188 ), DECODE( :B187 , :B9 , NULL, :B187 ), DECODE( :B186 , :B9 , NULL, :B186 ), DECODE( :B185 , :B9 , NULL, :B185 ), DECODE( :B184 , :B2 , NULL, :B184 ), DECODE( :B183 , :B2 , NULL, :B183 ), DECODE( :B182 , :B2 , NULL, :B182 ), DECODE( :B181 , :B2 , NULL, :B181 ), DECODE( :B180 , :B2 , NULL, :B180 ), DECODE( :B179 , :B2 , NULL, :B179 ), DECODE( :B178 , :B9 , NULL, :B178 ), DECODE( :B177 , :B9 , NULL, :B177 ), DECODE( :B176 , :B2 , NULL, :B176 ), DECODE( :B175 , :B2 , NULL, :B175 ), DECODE( :B174 , :B50 , TO_DATE(NULL), :B174 ), DECODE( :B173 , :B50 , TO_DATE(NULL), :B173 ), DECODE( :B172 , :B50 , TO_DATE(NULL), :B172 ), DECODE( :B171 , :B50 , TO_DATE(NULL), :B171 ), DECODE( :B170 , :B2 , NULL, :B170 ), DECODE( :B169 , :B2 , NULL, :B169 ), DECODE( :B168 , :B9 , NULL, :B168 ), DECODE( :B167 , :B9 , NULL, :B167 ), DECODE( :B166 , :B9 , NULL, :B166 ), DECODE( :B165 , :B9 , NULL, :B165 ), DECODE( :B164 , :B2 , NULL, :B164 ), DECODE( :B163 , :B2 , NULL, :B163 ), DECODE( :B162 , :B9 , NULL, :B162 ), DECODE( :B161 , :B9 , NULL, :B161 ), DECODE( :B160 , :B9 , NULL, :B160 ), DECODE( :B159 , :B9 , NULL, :B159 ), DECODE( :B158 , :B9 , NULL, :B158 ), DECODE( :B157 , :B9 , NULL, :B157 ), DECODE( :B156 , :B9 , NULL, :B156 ), DECODE( :B155 , :B9 , NULL, :B155 ), DECODE( :B154 , :B9 , NULL, :B154 ), DECODE( :B153 , :B9 , NULL, :B153 ), DECODE( :B152 , :B9 , NULL, :B152 ), DECODE( :B151 , :B9 , NULL, :B151 ), DECODE( :B150 , :B2 , NULL, :B150 ), DECODE( :B149 , :B2 , NULL, :B149 ), DECODE( :B148 , :B2 , NULL, :B148 ), DECODE( :B147 , :B2 , NULL, :B147 ), DECODE( :B146 , :B2 , NULL, :B146 ), DECODE( :B145 , :B2 , NULL, :B145 ), DECODE( :B144 , :B2 , NULL, :B144 ), DECODE( :B143 , :B2 , NULL, :B143 ), DECODE( :B142 , :B2 , NULL, :B142 ), DECODE( :B141 , :B2 , NULL, :B141 ), DECODE( :B140 , :B2 , NULL, :B140 ), DECODE( :B139 , :B2 , NULL, :B139 ), DECODE( :B138 , :B2 , NULL, :B138 ), DECODE( :B137 , :B2 , NULL, :B137 ), DECODE( :B136 , :B2 , NULL, :B136 ), DECODE( :B135 , :B2 , NULL, :B135 ), DECODE( :B134 , :B2 , NULL, :B134 ), DECODE( :B133 , :B2 , NULL,
:B133 ), DECODE( :B132 , :B2 , NULL, :B132 ), DECODE( :B131 , :B2 , NULL, :B131 ), DECODE( :B130 , :B2 , NULL, :B130 ), DECODE( :B129 , :B2 , NULL, :B129 ), DECODE( :B128 , :B2 , NULL, :B128 ), DECODE( :B127 , :B2 , NULL, :B127 ), DECODE( :B126 , :B2 , NULL, :B126 ), DECODE( :B125 , :B2 , NULL, :B125 ), DECODE( :B124 , :B2 , NULL, :B124 ), DECODE( :B123 , :B2 , NULL, :B123 ), DECODE( :B122 , :B2 , NULL, :B122 ), DECODE( :B121 , :B2 , NULL, :B121 ), DECODE( :B120 , :B2 , NULL, :B120 ), DECODE( :B119 , :B2 , NULL, :B119 ), DECODE( :B118 , :B2 , NULL, :B118 ), DECODE( :B117 , :B2 , NULL, :B117 ), DECODE( :B116 , :B2 , NULL, :B116 ), DECODE( :B115 , :B9 , NULL, :B115 ), DECODE( :B114 , :B50 , TO_DATE(NULL), :B114 ), DECODE( :B113 , :B9 , NULL, :B113 ), DECODE( :B112 , :B50 , TO_DATE(NULL), :B112 ), DECODE( :B111 , :B9 , NULL, :B111 ), DECODE( :B110 , :B9 , NULL, :B110 ), DECODE( :B109 , :B2 , NULL, :B109 ), DECODE( :B108 , :B2 , NULL, :B108 ), DECODE( :B107 , :B9 , NULL, :B107 ), DECODE( :B106 , :B9 , NULL, :B106 ), DECODE( :B105 , :B2 , NULL, :B105 ), DECODE( :B104 , :B2 , NULL, :B104 ), DECODE( :B103 , :B9 , NULL, :B103 ), DECODE( :B102 , :B9 , NULL, :B102 ), DECODE( :B101 , :B9 , NULL, :B101 ), DECODE( :B100 , :B9 , NULL, :B100 ), DECODE( :B99 , :B2 , NULL, :B99 ), DECODE( :B98 , :B2 , NULL, :B98 ), DECODE( :B97 , :B2 , NULL, :B97 ), DECODE( :B96 , :B2 , NULL, :B96 ), DECODE( :B95 , :B50 , TO_DATE(NULL), :B95 ), DECODE( :B94 , :B50 , TO_DATE(NULL), :B94 ), DECODE( :B93 , :B50 , TO_DATE(NULL), :B93 ), DECODE( :B92 , :B50 , TO_DATE(NULL), :B92 ), DECODE( :B91 , :B50 , TO_DATE(NULL), :B91 ), DECODE( :B90 , :B50 , TO_DATE(NULL), :B90 ), DECODE( :B89 , :B9 , NULL, :B89 ), DECODE( :B88 , :B9 , NULL, :B88 ), DECODE(:B87 , :B9 , NULL, :B87 ), DECODE(:B86 , :B9 , NULL, :B86 ), DECODE(:B85 , :B9 , NULL, :B85 ), DECODE(:B84 , :B9 , NULL, :B84 ), DECODE(:B83 , :B9 , NULL, :B83 ), DECODE(:B82 , :B9 , NULL, :B82 ), DECODE(:B81 , :B9 , NULL, :B81 ), DECODE(:B80 , :B9 , NULL, :B80 ), DECODE(:B79 , :B9 , NULL, :B79 ), DECODE(:B78 , :B9 , NULL, :B78 ), DECODE(:B77 , :B9 , NULL, :B77 ), DECODE(:B76 , :B9 , NULL, :B76 ), DECODE(:B75 , :B9 , NULL, :B75 ), DECODE(:B74 , :B9 , NULL, :B74 ), DECODE(:B73 , :B2 , NULL, :B73 ), DECODE(:B72 , :B2 , NULL, :B72 ), DECODE( :B71 , :B2 , NULL, :B71 ), DECODE( :B70 , :B2 , NULL, :B70 ), DECODE( :B69 , :B2 , NULL, :B69 ), DECODE( :B68 , :B2 , NULL, :B68 ), DECODE( :B67 , :B9 , NULL, :B67 ), DECODE( :B66 , :B9 , NULL, :B66 ), DECODE( :B65 , :B2 , NULL, :B65 ), DECODE( :B64 , :B2 , NULL, :B64 ), DECODE( :B63 , :B9 , NULL, :B63 ), DECODE( :B62 , :B9 , NULL, :B62 ), DECODE( :B61 , :B9 , NULL, :B61 ), DECODE( :B60 , :B9 , NULL, :B60 ), DECODE( :B59 , :B2 , NULL, :B59 ), DECODE( :B58 , :B2 , NULL, :B58 ), DECODE( :B57 , :B9 , NULL, :B57 ), DECODE( :B56 , :B9 , NULL, :B56 ), DECODE( :B55 , :B2 , NULL, :B55 ), DECODE( :B54 , :B2 , NULL, :B54 ), DECODE( :B53 , :B9 , NULL, :B53 ), DECODE( :B52 , :B9 , NULL, :B52 ), DECODE( :B51 , :B50 , TO_DATE(NULL), :B51 ), DECODE( :B49 , :B50 , TO_DATE(NULL), :B49 ), DECODE( :B48 , :B2 , NULL, :B48 ), DECODE( :B47 , :B2 , NULL, :B47 ), DECODE( :B46 , :B2 , NULL, :B46 ), DECODE( :B45 , :B2 , NULL, :B45 ), DECODE( :B44 , :B2 , NULL, :B44 ), DECODE( :B43 , :B2 , NULL, :B43 ), DECODE( :B42 , :B2 , NULL, :B42 ), DECODE( :B41 , :B2 , NULL, :B41 ), DECODE( :B40 , :B2 , NULL, :B40 ), DECODE( :B39 , :B2 , NULL, :B39 ), DECODE( :B38 , :B2 , NULL, :B38 ), DECODE( :B37 , :B2 , NULL, :B37 ), DECODE( :B36 , :B2 , NULL, :B36 ), DECODE( :B35 , :B2 , NULL, :B35 ), DECODE( :B34 , :B2 , NULL, :B34 ), DECODE( :B33 , :B2 , NULL, :B33 ), DECODE( :B32 , :B2 , NULL, :B3
2 ), DECODE( :B31 , :B2 , NULL, :B31 ), DECODE( :B30 , :B2 , NULL, :B30 ), DECODE( :B29 , :B2 , NULL, :B29 ), DECODE( :B28 , :B2 , NULL, :B28 ), DECODE( :B27 , :B2 , NULL, :B27 ), DECODE( :B26 , :B2 , NULL, :B26 ), DECODE( :B25 , :B2 , NULL, :B25 ), DECODE( :B24 , :B2 , NULL, :B24 ), DECODE( :B23 , :B2 , NULL, :B23 ), DECODE( :B22 , :B2 , NULL, :B22 ), DECODE( :B21 , :B2 , NULL, :B21 ), DECODE( :B20 , :B2 , NULL, :B20 ), DECODE( :B19 , :B2 , NULL, :B19 ), DECODE( :B18 , :B9 , NULL, :B18 ), DECODE( :B17 , :B9 , NULL, :B17 ), DECODE( :B16 , :B2 , NULL, :B16 ), DECODE( :B15 , :B2 , NULL, :B15 ), DECODE( :B14 , :B9 , NULL, :B14 ), DECODE( :B13 , :B9 , NULL, :B13 ), DECODE( :B12 , :B2 , NULL, :B12 ), DECODE( :B11 , :B2 , NULL, :B11 ), DECODE( :B10 , :B9 , NULL, :B10 ), DECODE( :B8 , :B9 , NULL, :B8 ), DECODE( :B7 , :B2 , NULL, :B7 ), DECODE( :B6 , :B2 , NULL, :B6 ), DECODE( :B5 , :B2 , NULL, :B5 ), DECODE( :B4 , :B2 , NULL, :B4 ), DECODE( :B3 , :B2 , NULL, :B3 ), DECODE( :B1 , :B2 , NULL, :B1 ) ) |
| 5b7p43uucnqp7 | SELECT LINK_TO_LINE_ID, ITEM_TYPE_CODE FROM OE_ORDER_LINES WHERE LINE_ID = :B1 |
| 65qczrm0turbh | UPDATE OE_ORDER_LINES SET OPEN_FLAG = :B7 , CALCULATE_PRICE_FLAG = :B6 , FLOW_STATUS_CODE = :B5 , LAST_UPDATED_BY = :B4 , LAST_UPDATE_LOGIN = :B3 , LAST_UPDATE_DATE = :B2 , LOCK_CONTROL = :B1 WHERE LINE_ID = :B8 |
| 6hnnphk96ubbn | SELECT CREATION_SIGN FROM RA_CUST_TRX_TYPES WHERE CUST_TRX_TYPE_ID = :B1 |
| 6mu4cfrayu648 | SELECT 'x' FROM WSH_PR_WORKERS WHERE ROWID = :B1 AND PROCESSED = 'N' FOR UPDATE NOWAIT |
| 6y4hc0kmbhrff | INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUSTOMER_TRX_LINE_ID, CUSTOMER_TRX_ID, CODE_COMBINATION_ID, SET_OF_BOOKS_ID, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, PERCENT, AMOUNT, ACCTD_AMOUNT, GL_DATE, CUST_TRX_LINE_SALESREP_ID, REQUEST_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, POSTING_CONTROL_ID, ORIGINAL_GL_DATE, CUST_TRX_LINE_GL_DIST_ID, COLLECTED_TAX_CCID, ORG_ID ) SELECT TAX_LINE.CUSTOMER_TRX_LINE_ID, TAX_LINE.CUSTOMER_TRX_ID, TAX.CODE_COMBINATION_ID, :B9 , TAX.ACCOUNT_CLASS, 'N', TAX.PERCENT, DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( ((TAX.PERCENT / 100) * TAX_LINE.EXTENDED_AMOUNT), FC.PRECISION), ROUND( ((TAX.PERCENT / 100) * TAX_LINE.EXTENDED_AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), DECODE(:B7 , NULL, ROUND( NVL(TRX.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( ((TAX.PERCENT / 100) * TAX_LINE.EXTENDED_AMOUNT), FC.PRECISION), ROUND( ((TAX.PERCENT / 100) * TAX_LINE.EXTENDED_AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT), :B8 ), ROUND( ( NVL(TRX.EXCHANGE_RATE, 1) * DECODE(FC.MINIMUM_ACCOUNTABLE_UNIT, NULL, ROUND( ((TAX.PERCENT / 100) * TAX_LINE.EXTENDED_AMOUNT), FC.PRECISION), ROUND( ((TAX.PERCENT / 100) * TAX_LINE.EXTENDED_AMOUNT) / FC.MINIMUM_ACCOUNTABLE_UNIT) * FC.MINIMUM_ACCOUNTABLE_UNIT)) / :B7 ) * :B7 ), DECODE(REC.GL_DATE, NULL, NULL, ARP_AUTO_RULE.ASSIGN_GL_REC(REC.GL_DATE) ), TAX.CUST_TRX_LINE_SALESREP_ID, :B6 , :B5 , SYSDATE, :B5 , SYSDATE, :B4 , :B3 , SYSDATE, -3, NVL( NVL(REC.ORIGINAL_GL_DATE, REC.GL_DATE), TRX.TRX_DATE), RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL, TAX.COLLECTED_TAX_CCID, TRX.ORG_ID FROM RA_CUSTOMER_TRX MODEL_TRX, RA_CUST_TRX_LINE_GL_DIST TAX, RA_CUSTOMER_TRX_LINES TAX_LINE, RA_CUSTOMER_TRX_LINES LINE_LINE, RA_CUST_TRX_LINE_GL_DIST REC, FND_CURRENCIES FC, RA_CUSTOMER_TRX TRX WHERE TRX.CUSTOMER_TRX_ID = :B2 AND TRX.COMPLETE_FLAG = 'Y' AND FC.CURRENCY_CODE = TRX.INVOICE_CURRENCY_CODE AND REC.CUSTOMER_TRX_ID = TRX.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS = 'REC' AND REC.LATEST_REC_FLAG = 'Y' AND LINE_LINE.CUSTOMER_TRX_ID = REC.CUSTOMER_TRX_ID AND (LINE_LINE.AUTORULE_COMPLETE_FLAG||'' = 'N' OR :B1 = 'Y') AND TAX_LINE.LINK_TO_CUST_TRX_LINE_ID = LINE_LINE.CUSTOMER_TRX_LINE_ID AND TAX_LINE.LINE_TYPE = 'TAX' AND TAX_LINE.CUSTOMER_TRX_ID + 0 = LINE_LINE.CUSTOMER_TRX_ID AND TRX.CUSTOMER_TRX_ID = TAX_LINE.CUSTOMER_TRX_ID AND MODEL_TRX.CUSTOMER_TRX_ID = TAX.CUSTOMER_TRX_ID AND TAX.ACCOUNT_CLASS = 'TAX' AND TAX.CUSTOMER_TRX_LINE_ID = (SELECT DECODE( COUNT(CUST_TRX_LINE_GL_DIST_ID), 0, NVL(TAX_LINE.PREVIOUS_CUSTOMER_TRX_LINE_ID, TAX_LINE.CUSTOMER_TRX_LINE_ID), TAX_LINE.CUSTOMER_TRX_LINE_ID) FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST2 WHERE SUBDIST2.CUSTOMER_TRX_LINE_ID=TAX_LINE.CUSTOMER_TRX_LINE_ID AND SUBDIST2.ACCOUNT_SET_FLAG = 'Y' AND SUBDIST2.GL_DATE IS NULL AND ROWNUM < 2 ) AND ( TAX.ACCOUNT_SET_FLAG = 'Y' OR MODEL_TRX.CREATED_FROM IN ('RAXTRX_REL9', 'FORM_REL9') ) AND NOT EXISTS (SELECT 'tax account exists' FROM RA_CUST_TRX_LINE_GL_DIST SUBDIST WHERE TAX_LINE.CUSTOMER_TRX_LINE_ID = SUBDIST.CUSTOMER_TRX_LINE_ID AND SUBDIST.ACCOUNT_SET_FLAG = 'N' AND SUBDIST.GL_DATE IS NOT NULL AND SUBDIST.ACCOUNT_CLASS = 'TAX' ) |
| 7gup25397xndk | SELECT SOURCE_TYPE_CODE, ITEM_TYPE_CODE, ATO_LINE_ID FROM OE_ORDER_LINES WHERE LINE_ID = :B1 |
| 7qh9zcbrq9ky7 | SELECT 'Y' FROM WSH_PR_WORKERS WHERE ROWID = :B1 AND PROCESSED = 'N' FOR UPDATE NOWAIT |
| 7qs7fx89194u1 | SELECT PROFILE_OPTION_VALUE FROM FND_PROFILE_OPTION_VALUES WHERE PROFILE_OPTION_ID = :B4 AND APPLICATION_ID = :B3 AND LEVEL_ID = :B2 AND LEVEL_VALUE = :B1 AND PROFILE_OPTION_VALUE IS NOT NULL |
| 7yxbh5wb5zv9t | SELECT LINE_COLLECTIBLE_FLAG FROM AR_DEFERRED_LINES WHERE CUSTOMER_TRX_ID = :B2 AND CUSTOMER_TRX_LINE_ID = :B1 |
| 84czzn8ws6y5t | SELECT LOCATION_ID FROM PO_LOCATION_ASSOCIATIONS WHERE SITE_USE_ID = :B1 |
| 8swypbbr0m372 | select order#, columns, types from access$ where d_obj#=:1 |
| 8w57t3xaxs89k | SELECT NAME, VERSION FROM FND_CACHE_VERSIONS |
| 98dpj4cn73gd3 | SELECT REFERENCE_LINE_ID, LINE_CATEGORY_CODE FROM OE_ORDER_LINES WHERE LINE_ID = :B1 |
| 9m52p59waknpu | SELECT HEADER_ID, ORG_ID, SHIP_FROM_ORG_ID, SOLD_TO_ORG_ID, COMMITMENT_ID, SALESREP_ID, INVENTORY_ITEM_ID, ITEM_TYPE_CODE, ORDER_SOURCE_ID, ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF, CHANGE_SEQUENCE, SOURCE_DOCUMENT_TYPE_ID, SOURCE_DOCUMENT_ID, SOURCE_DOCUMENT_LINE_ID FROM OE_ORDER_LINES WHERE LINE_ID = :B1 |
| 9tgj4g8y4rwy8 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
| a3d4khyx5kbad | SELECT NVL(PICKING_CREDIT_CHECK_RULE_ID, -1) FROM OE_ORDER_TYPES_V OT, OE_CREDIT_CHECK_RULES CCR WHERE OT.ORDER_TYPE_ID = :B1 AND PICKING_CREDIT_CHECK_RULE_ID=CCR.CREDIT_CHECK_RULE_ID AND TRUNC(SYSDATE) BETWEEN NVL(CCR.START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(CCR.END_DATE_ACTIVE, TRUNC(SYSDATE)) |
| a43whfj9kfzrc |
INSERT INTO ZX_TRANSACTION_LINES_GT ( APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, INTERFACE_ENTITY_CODE, INTERFACE_LINE_ID, TRX_ID, TRX_LEVEL_TYPE, TRX_LINE_ID, LINE_CLASS, LINE_LEVEL_ACTION, TRX_SHIPPING_DATE, TRX_LINE_TYPE, TRX_LINE_DATE, LINE_AMT_INCLUDES_TAX_FLAG, LINE_AMT, TRX_LINE_QUANTITY, UNIT_PRICE, EXEMPT_CERTIFICATE_NUMBER, EXEMPT_REASON_CODE, EXEMPTION_CONTROL_FLAG, PRODUCT_ID, PRODUCT_ORG_ID, UOM_CODE, FOB_POINT, SHIP_FROM_PARTY_ID, SHIP_FROM_LOCATION_ID, SHIP_TO_PARTY_ID, SHIP_TO_PARTY_SITE_ID, BILL_TO_PARTY_ID, BILL_TO_PARTY_SITE_ID, ADJUSTED_DOC_APPLICATION_ID, ADJUSTED_DOC_ENTITY_CODE, ADJUSTED_DOC_EVENT_CLASS_CODE, ADJUSTED_DOC_TRX_ID, ADJUSTED_DOC_LINE_ID, ADJUSTED_DOC_TRX_LEVEL_TYPE, ADJUSTED_DOC_NUMBER, ADJUSTED_DOC_DATE, SOURCE_APPLICATION_ID, SOURCE_ENTITY_CODE, SOURCE_EVENT_CLASS_CODE, SOURCE_TRX_ID, SOURCE_LINE_ID, SOURCE_TRX_LEVEL_TYPE, SOURCE_TAX_LINE_ID, OUTPUT_TAX_CLASSIFICATION_CODE, TRX_LINE_NUMBER, HISTORICAL_FLAG, CTRL_HDR_TX_APPL_FLAG, TRX_LINE_GL_DATE, SHIP_TO_LOCATION_ID, BILL_TO_LOCATION_ID, TRX_LINE_CURRENCY_CODE, TRX_LINE_PRECISION, TRX_LINE_MAU, SHIP_THIRD_PTY_ACCT_ID, SHIP_THIRD_PTY_ACCT_SITE_ID, SHIP_TO_CUST_ACCT_SITE_USE_ID, POA_PARTY_ID, POA_LOCATION_ID, POO_PARTY_ID, POO_LOCATION_ID, CASH_DISCOUNT, BILL_FROM_LOCATION_ID, TRX_BUSINESS_CATEGORY, PRODUCT_FISC_CLASSIFICATION, PRODUCT_CATEGORY, PRODUCT_TYPE, LINE_INTENDED_USE, ASSESSABLE_VALUE, USER_DEFINED_FISC_CLASS, ACCOUNT_CCID, TRX_LINE_DESCRIPTION ) SELECT 222, ZTH.ENTITY_CODE, ZTH.EVENT_CLASS_CODE, 'RA_INTERFACE_LINES', TL.CUSTOMER_TRX_LINE_ID, TL.CUSTOMER_TRX_ID, 'LINE', TL.CUSTOMER_TRX_LINE_ID, ZTH.EVENT_CLASS_CODE, DECODE(TL.LINE_TYPE, 'CHARGES', 'RECORD_WITH_NO_TAX', DECODE(NVL(ITL.TAXABLE_FLAG, TL.TAXABLE_FLAG), 'N', 'RECORD_WITH_NO_TAX', DECODE(ML.LINE_TYPE, 'TAX', 'LINE_INFO_TAX_ONLY', 'CREATE'))), NVL(TL.SALES_ORDER_DATE, T.SHIP_DATE_ACTUAL), DECODE(TL.INVENTORY_ITEM_ID, NULL, 'MISC', 'ITEM'), NULL, DECODE(TL.AMOUNT_INCLUDES_TAX_FLAG, 'Y', 'A', 'N', 'N', 'S'), TL.EXTENDED_AMOUNT, DECODE(ZTH.EVENT_CLASS_CODE, 'CREDIT_MEMO', NVL(TL.QUANTITY_CREDITED, TL.QUANTITY_INVOICED), TL.QUANTITY_INVOICED), TL.UNIT_SELLING_PRICE, TL.TAX_EXEMPT_NUMBER, TL.TAX_EXEMPT_REASON_CODE, TL.TAX_EXEMPT_FLAG, NVL(TL.INVENTORY_ITEM_ID, TL.MEMO_LINE_ID), DECODE(TL.MEMO_LINE_ID, NULL, NVL(TL.WAREHOUSE_ID, TO_NUMBER(:B3 )), NULL), TL.UOM_CODE, T.FOB_POINT, TL.WAREHOUSE_ID, HR.LOCATION_ID, STCA.PARTY_ID, STPS.PARTY_SITE_ID, ZTH.ROUNDING_BILL_TO_PARTY_ID, ZTH.RNDG_BILL_TO_PARTY_SITE_ID, DECODE(TL.PREVIOUS_CUSTOMER_TRX_LINE_ID, NULL, NULL, 222), DECODE(TL.PREVIOUS_CUSTOMER_TRX_LINE_ID, NULL, NULL, 'TRANSACTIONS'), DECODE(TL.PREVIOUS_CUSTOMER_TRX_LINE_ID, NULL, NULL, DECODE(ITT.TYPE, 'DM', 'DEBIT_MEMO', 'INVOICE')), DECODE(TL.PREVIOUS_CUSTOMER_TRX_LINE_ID, NULL, NULL, T.PREVIOUS_CUSTOMER_TRX_ID), DECODE(TL.PREVIOUS_CUSTOMER_TRX_LINE_ID, NULL, NULL, TL.PREVIOUS_CUSTOMER_TRX_LINE_ID), DECODE(TL.PREVIOUS_CUSTOMER_TRX_LINE_ID, NULL, NULL, 'LINE'), DECODE(T.PREVIOUS_CUSTOMER_TRX_ID, NULL, NULL, IT.TRX_NUMBER), DECODE(T.PREVIOUS_CUSTOMER_TRX_ID, NULL, NULL, IT.TRX_DATE), RIL.SOURCE_APPLICATION_ID, RIL.SOURCE_ENTITY_CODE, RIL.SOURCE_EVENT_CLASS_CODE, RIL.SOURCE_TRX_ID, RIL.SOURCE_TRX_LINE_ID, RIL.SOURCE_TRX_LINE_TYPE, RIL.SOURCE_TRX_DETAIL_TAX_LINE_ID, TL.TAX_CLASSIFICATION_CODE, TL.LINE_NUMBER, TL.HISTORICAL_FLAG, 'N', NVL(REC.GL_DATE, TRUNC(SYSDATE)), STPSU.LOCATION_ID, BTPSU.LOCATION_ID, ZTH.TRX_CURRENCY_CODE, ZTH.PRECISION, ZTH.MINIMUM_ACCOUNTABLE_UNIT, TL.SHIP_TO_CUSTOMER_ID, STPS.CUST_ACCT_SITE_ID, STCSU.SITE_USE_ID, ZTH.INTERNAL_ORGANIZATION_ID, ZTH.INTERNAL_ORG_LOCATION_ID, ZTH.INTERNAL_ORGANIZATION_ID, ZTH.INTERNAL_ORG_LOCATION_ID, TL.EXTENDED_AMOUNT * ARP_ETAX_UTIL.GET_DISCOUNT_RATE(T.CUSTOMER_TRX_ID), ZTH.INTERNAL_ORG_LOCATION_ID, RIL.TRX_BUSINESS_CATEGORY, RIL.PRODUCT_FISC_
CLASSIFICATION, NVL(RIL.PRODUCT_CATEGORY, ML.TAX_PRODUCT_CATEGORY), RIL.PRODUCT_TYPE, RIL.LINE_INTENDED_USE, RIL.ASSESSABLE_VALUE, RIL.USER_DEFINED_FISC_CLASS, ( SELECT DECODE( :B1 , 'CM', NULL, CODE_COMBINATION_ID) FROM RA_CUST_TRX_LINE_GL_DIST GLD WHERE ROWNUM = 1 AND GLD.CUSTOMER_TRX_LINE_ID = TL.CUSTOMER_TRX_LINE_ID AND GLD.ACCOUNT_CLASS = 'REV' AND GLD.REQUEST_ID = TL.REQUEST_ID) ACCOUNT_CCID, TL.DESCRIPTION FROM RA_CUSTOMER_TRX_LINES TL, RA_CUSTOMER_TRX T, RA_INTERFACE_LINES RIL, ZX_TRX_HEADERS_GT ZTH, HZ_CUST_ACCOUNTS STCA, HZ_CUST_ACCT_SITES STPS, HZ_CUST_SITE_USES STCSU, RA_CUSTOMER_TRX IT, RA_CUST_TRX_TYPES ITT, RA_CUSTOMER_TRX_LINES ITL, RA_CUST_TRX_LINE_GL_DIST REC, HZ_PARTY_SITES STPSU, HZ_PARTY_SITES BTPSU, HR_ALL_ORGANIZATION_UNITS HR, AR_MEMO_LINES_B ML WHERE TL.REQUEST_ID = :B2 AND TL.LINE_TYPE IN ('LINE', 'CHARGES') AND TL.CUSTOMER_TRX_ID = T.CUSTOMER_TRX_ID AND TL.CUSTOMER_TRX_LINE_ID = RIL.INTERFACE_LINE_ID (+) AND TL.CUSTOMER_TRX_ID = ZTH.TRX_ID AND NVL(T.PREVIOUS_CUSTOMER_TRX_ID, -99) = DECODE(:B1 , 'INV', -99, T.PREVIOUS_CUSTOMER_TRX_ID) AND TL.SHIP_TO_CUSTOMER_ID = STCA.CUST_ACCOUNT_ID (+) AND TL.SHIP_TO_SITE_USE_ID = STCSU.SITE_USE_ID (+) AND STCSU.CUST_ACCT_SITE_ID = STPS.CUST_ACCT_SITE_ID (+) AND STPS.PARTY_SITE_ID = STPSU.PARTY_SITE_ID (+) AND ZTH.RNDG_BILL_TO_PARTY_SITE_ID = BTPSU.PARTY_SITE_ID AND T.PREVIOUS_CUSTOMER_TRX_ID = IT.CUSTOMER_TRX_ID (+) AND IT.CUST_TRX_TYPE_ID = ITT.CUST_TRX_TYPE_ID (+) AND TL.PREVIOUS_CUSTOMER_TRX_LINE_ID = ITL.CUSTOMER_TRX_LINE_ID (+) AND REC.CUSTOMER_TRX_ID (+) = T.CUSTOMER_TRX_ID AND REC.ACCOUNT_CLASS (+) = 'REC' AND REC.LATEST_REC_FLAG (+) = 'Y' AND TL.WAREHOUSE_ID = HR.ORGANIZATION_ID (+) AND TL.MEMO_LINE_ID = ML.MEMO_LINE_ID (+) AND TL.ORG_ID = ML.ORG_ID (+) |
| ak5crjygnpk60 | UPDATE DBMS_LOCK_ALLOCATED SET EXPIRATION = SYSDATE + (:B1 /86400) WHERE ROWID = :B2 |
| ap9ujq27jvtzg |
select int.rowid , decode(int.SEGMENT1|| int.SEGMENT2|| int.SEGMENT3|| int.SEGMENT4|| int.SEGMENT5 , :"SYS_B_000", decode (ccid_cc.code_combination_id, NULL, NULL, replace(ccid_cc.SEGMENT3, :"SYS_B_001", :"SYS_B_002") || :"SYS_B_003" || replace(ccid_cc.SEGMENT1, :"SYS_B_004", :"SYS_B_005") || :"SYS_B_006" || replace(ccid_cc.SEGMENT2, :"SYS_B_007", :"SYS_B_008") || :"SYS_B_009" || replace(ccid_cc.SEGMENT4, :"SYS_B_010", :"SYS_B_011") || :"SYS_B_012" || replace(ccid_cc.SEGMENT5, :"SYS_B_013", :"SYS_B_014") ), replace(int.SEGMENT3, :"SYS_B_015", :"SYS_B_016") || :"SYS_B_017" || replace(int.SEGMENT1, :"SYS_B_018", :"SYS_B_019") || :"SYS_B_020" || replace(int.SEGMENT2, :"SYS_B_021", :"SYS_B_022") || :"SYS_B_023" || replace(int.SEGMENT4, :"SYS_B_024", :"SYS_B_025") || :"SYS_B_026" || replace(int.SEGMENT5, :"SYS_B_027", :"SYS_B_028") ) flexfield , nvl(flex_cc.code_combination_id, nvl(int.code_combination_id, -:"SYS_B_029")) , decode(int.SEGMENT1|| int.SEGMENT2|| int.SEGMENT3|| int.SEGMENT4|| int.SEGMENT5 , :"SYS_B_030", decode(ccid_cc.code_combination_id, null, decode(int.code_combination_id, null, -:"SYS_B_031", -:"SYS_B_032"), decode(sign(nvl(ccid_cc.start_date_active, int.accounting_date-:"SYS_B_033") - int.accounting_date), :"SYS_B_034", -:"SYS_B_035", decode(sign(nvl(ccid_cc.end_date_active, int.accounting_date +:"SYS_B_036") - int.accounting_date), -:"SYS_B_037", -:"SYS_B_038", :"SYS_B_039")) + decode(ccid_cc.enabled_flag, :"SYS_B_040", -:"SYS_B_041", :"SYS_B_042") + decode(ccid_cc.summary_flag, :"SYS_B_043", -:"SYS_B_044", decode(int.actual_flag, :"SYS_B_045", decode(ccid_cc.detail_budgeting_allowed_flag, :"SYS_B_046", -:"SYS_B_047", :"SYS_B_048"), decode(ccid_cc.detail_posting_allowed_flag, :"SYS_B_049", -:"SYS_B_050", :"SYS_B_051")))), decode(flex_cc.code_combination_id, null, -:"SYS_B_052", decode(sign(nvl(flex_cc.start_date_active, int.accounting_date-:"SYS_B_053") - int.accounting_date), :"SYS_B_054", -:"SYS_B_055", decode(sign(nvl(flex_cc.end_date_active, int.accounting_date +:"SYS_B_056") - int.accounting_date), -:"SYS_B_057", -:"SYS_B_058", :"SYS_B_059")) + decode(flex_cc.enabled_flag, :"SYS_B_060", -:"SYS_B_061", :"SYS_B_062") + decode(flex_cc.summary_flag, :"SYS_B_063", -:"SYS_B_064", decode(int.actual_flag, :"SYS_B_065", decode(flex_cc.detail_budgeting_allowed_flag, :"SYS_B_066", -:"SYS_B_067", :"SYS_B_068"), decode(flex_cc.detail_posting_allowed_flag, :"SYS_B_069", -:"SYS_B_070", :"SYS_B_071"))))) , int.user_je_category_name , decode(actual_flag, :"SYS_B_072" , decode(period_name, NULL, :"SYS_B_073" , period_name), nvl(period_name, :"SYS_B_074")) period_name , int.currency_code , decode(actual_flag , :"SYS_B_075", :"SYS_B_076" , :"SYS_B_077", decode(budget_version_id, NULL, :"SYS_B_078", :"SYS_B_079") , :"SYS_B_080", decode(encumbrance_type_id , :"SYS_B_081", actual_flag , :"SYS_B_082", actual_flag , :"SYS_B_083", actual_flag , :"SYS_B_084", actual_flag , :"SYS_B_085", actual_flag , :"SYS_B_086", actual_flag , :"SYS_B_087", actual_flag , :"SYS_B_
088", actual_flag , :"SYS_B_089", actual_flag , :"SYS_B_090", actual_flag , :"SYS_B_091", actual_flag , :"SYS_B_092", actual_flag , :"SYS_B_093", actual_flag , :"SYS_B_094", actual_flag , :"SYS_B_095", actual_flag , :"SYS_B_096", actual_flag , :"SYS_B_097", actual_flag , NULL, :"SYS_B_098", :"SYS_B_099"), :"SYS_B_100") actual_flag , decode(int.currency_code , :"SYS_B_101", :"SYS_B_102" , decode(actual_flag, :"SYS_B_103", -:"SYS_B_104", :"SYS_B_105", :"SYS_B_106" , decode(user_currency_conversion_type , :"SYS_B_107", decode(currency_conversion_rate, NULL, -:"SYS_B_108", currency_conversion_rate) , NULL, decode(currency_conversion_rate, NULL, decode(decode(nvl(to_char(entered_dr), :"SYS_B_109"), :"SYS_B_110", :"SYS_B_111", :"SYS_B_112"), decode(nvl(to_char(accounted_dr), :"SYS_B_113"), :"SYS_B_114", :"SYS_B_115", :"SYS_B_116"), decode(decode(nvl(to_char(entered_cr), :"SYS_B_117"), :"SYS_B_118", :"SYS_B_119", :"SYS_B_120"), decode(nvl(to_char(accounted_cr), :"SYS_B_121"), :"SYS_B_122", :"SYS_B_123", :"SYS_B_124") , -:"SYS_B_125", -:"SYS_B_126"), -:"SYS_B_127"), -:"SYS_B_128"), decode(currency_conversion_date, NULL, -:"SYS_B_129", -:"SYS_B_130")))) currency_conversion_rate , nvl(to_number(to_char(int.currency_conversion_date, :"SYS_B_131")), :"SYS_B_132") , decode(int.actual_flag , :"SYS_B_133", decode(int.currency_code , :"SYS_B_134", :"SYS_B_135" , nvl(int.user_currency_conversion_type, :"SYS_B_136")) , :"SYS_B_137", :"SYS_B_138", :"SYS_B_139", :"SYS_B_140" , nvl(int.user_currency_conversion_type, :"SYS_B_141")) user_currency_conversion_type , ltrim(rtrim(substrb(int.reference1 || :"SYS_B_142" || int.user_je_source_name || :"SYS_B_143" || int.actual_flag || :"SYS_B_144" || int.group_id, :"SYS_B_145", :"SYS_B_146"))) , rtrim(substrb(nvl(rtrim(int.reference2), :"SYS_B_147" || int.user_je_source_name || :"SYS_B_148"), :"SYS_B_149", :"SYS_B_150")) , ltrim(rtrim(substrb(rtrim(int.reference4 || :"SYS_B_151" || int.user_je_category_name || :"SYS_B_152" || int.currency_code || decode(int.actual_flag, :"SYS_B_153", :"SYS_B_154" || int.encumbrance_type_id, :"SYS_B_155", :"SYS_B_156" || int.budget_version_id, :"SYS_B_157") || :"SYS_B_158" || int.user_currency_conversion_type || :"SYS_B_159" || decode(int.user_currency_conversion_type, NULL, :"SYS_B_160", :"SYS_B_161", to_char(int.currency_conversion_rate), to_char(int.currency_conversion_date))) || :"SYS_B_162" || int.originating_bal_seg_value, :"SYS_B_163", :"SYS_B_164"))) , rtrim(nvl(rtrim(int.reference5), :"SYS_B_165")) , rtrim(substrb(nvl(rtrim(int.reference6), :"SYS_B_166"), :"SYS_B_167", :"SYS_B_168")) , rtrim(decode(upper(substrb(nvl(rtrim(int.reference7), :"SYS_B_169"), :"SYS_B_170", :"SYS_B_171")), :"SYS_B_172", :"SYS_B_173", :"SYS_B_174")) , decode(upper(substrb(int.reference7, :"SYS_B_175", :"SYS_B_176")), :"SYS_B_177", decode(rtrim(reference8), NULL, :"SYS_B_178", rtrim(substrb(reference8, :"SYS_B_179", :"SYS_B_180"))), NULL) , decode(rtrim(upper(substrb(int.reference9,
:"SYS_B_181", :"SYS_B_182"))), :"SYS_B_183", :"SYS_B_184", :"SYS_B_185", :"SYS_B_186", NULL) , rtrim(nvl(rtrim(int.reference10), nvl(to_char(int.subledger_doc_sequence_value), :"SYS_B_187"))) , int.entered_dr , int.entered_cr , to_number(to_char(int.accounting_date, :"SYS_B_188")) , to_char(int.accounting_date, :"SYS_B_189") , int.user_je_source_name , nvl(int.encumbrance_type_id, -:"SYS_B_190") , nvl(int.budget_version_id, -:"SYS_B_191") , NULL , decode(int.stat_amount, :"SYS_B_192", :"SYS_B_193", int.stat_amount) , decode(int.actual_flag , :"SYS_B_194", decode(int.currency_code, :"SYS_B_195", :"SYS_B_196", :"SYS_B_197"), :"SYS_B_198") , decode(int.actual_flag , :"SYS_B_199", decode(int.budget_version_id , NULL, decode(int.encumbrance_type_id, NULL, :"SYS_B_200", :"SYS_B_201") , decode(int.encumbrance_type_id, NULL, :"SYS_B_202", :"SYS_B_203")) , :"SYS_B_204", decode(int.encumbrance_type_id , NULL, :"SYS_B_205", :"SYS_B_206") , :"SYS_B_207", decode(int.budget_version_id , NULL, :"SYS_B_208", :"SYS_B_209"), :"SYS_B_210") , int.accounted_dr , int.accounted_cr , nvl(int.group_id, -:"SYS_B_211") , nvl(int.average_journal_flag, :"SYS_B_212") , int.originating_bal_seg_value , decode(nvl(int.ledger_id, -:"SYS_B_213"), -:"SYS_B_214", int.set_of_books_id, int.ledger_id) , nvl(to_char(int.reference_date, :"SYS_B_215"), :"SYS_B_216") , nvl(upper(int.funds_reserved_flag), :"SYS_B_217") from XLA_GLT_199476 int, gl_code_combinations flex_cc, gl_code_combinations ccid_cc where int.status != :"SYS_B_218" and (int.user_je_source_name, group_id, -:"SYS_B_219") in ( (:src0, :grp0, :lgr0) ) and flex_cc.SEGMENT1(+) = int.SEGMENT1 and flex_cc.SEGMENT2(+) = int.SEGMENT2 and flex_cc.SEGMENT3(+) = int.SEGMENT3 and flex_cc.SEGMENT4(+) = int.SEGMENT4 and flex_cc.SEGMENT5(+) = int.SEGMENT5 and flex_cc.chart_of_accounts_id(+) = :coa1_id and flex_cc.template_id(+) is NULL and ccid_cc.code_combination_id(+) = int.code_combination_id and ccid_cc.chart_of_accounts_id(+) = : coa2_id and ccid_cc.template_id(+) is NULL order by decode(nvl(int.ledger_id, -:"SYS_B_220"), -:"SYS_B_221", int.set_of_books_id, int.ledger_id), decode(int.SEGMENT1|| int.SEGMENT2|| int.SEGMENT3|| int.SEGMENT4|| int.SEGMENT5 , :"SYS_B_222" , rpad(ccid_cc.SEGMENT3, :"SYS_B_223") || :"SYS_B_224" || rpad(ccid_cc.SEGMENT1, :"SYS_B_225") || :"SYS_B_226" || rpad(ccid_cc.SEGMENT2, :"SYS_B_227") || :"SYS_B_228" || rpad(ccid_cc.SEGMENT4, :"SYS_B_229") || :"SYS_B_230" || rpad(ccid_cc.SEGMENT5, :"SYS_B_231") , rpad(int.SEGMENT3, :"SYS_B_232") || :"SYS_B_233" || rpad(int.SEGMENT1, :"SYS_B_234") || :"SYS_B_235" || rpad(int.SEGMENT2, :"SYS_B_236") || :"SYS_B_237" || rpad(int.SEGMENT4, :"SYS_B_238") || :"SYS_B_239" || rpad(int.SEGMENT5, :"SYS_B_240") ) , int.entered_dr, int.accounted_dr, int.entered_cr, int.accounted_cr, int.accounting_date , int.reference1 || int.user_je_source_name || int.group_id || int.actual_flag || int.average_journal_flag , int.reference4 || int.user_je_category_name || int.currency_code || int.encumbrance_type_id || int.budget_version_id || int.user_currency_conversion_type || int.currency_conversion_date || int.currency_conversion_rate || int.reference7 || int.originating_bal_seg_value
|
| aptgswyxvu4ws | SELECT COUNT ( * ) FROM RA_INTERFACE_ERRORS ERR , RA_INTERFACE_LINES LINES WHERE LINES . REQUEST_ID = :B1 AND LINES . INTERFACE_LINE_ID = ERR . INTERFACE_LINE_ID |
| c64uqd4zbqsqc | SELECT ORDER_CATEGORY_CODE, ORDER_TYPE_ID FROM OE_ORDER_HEADERS WHERE HEADER_ID = :B1 |
| drt9k4tpvph64 | SELECT AR_TAX.LOCATION_SEGMENT_ID, AR_TAX.ORG_ID, AR_TAX.TAX_LINE_ID, AR_TAX.VAT_TAX_ID, AR_TAX.SET_OF_BOOKS_ID, NVL(AR_REC.GL_DATE, TRUNC(SYSDATE)) FROM RA_CUSTOMER_TRX_LINES AR_TAX, RA_CUST_TRX_LINE_GL_DIST AR_REC WHERE AR_TAX.CUSTOMER_TRX_LINE_ID = :B1 AND AR_TAX.CUSTOMER_TRX_ID = AR_REC.CUSTOMER_TRX_ID AND AR_REC.ACCOUNT_CLASS = 'REC' AND AR_REC.LATEST_REC_FLAG = 'Y' |
| dvd0dadfqk23r | UPDATE MTL_TRANSACTIONS_INTERFACE MTI SET LAST_UPDATE_DATE = SYSDATE, LAST_UPDATED_BY = :B5 , LAST_UPDATE_LOGIN = :B4 , PROGRAM_UPDATE_DATE = SYSDATE, PROCESS_FLAG = 3, LOCK_FLAG = 2, ERROR_CODE = SUBSTRB(:B3 , 1, 240), ERROR_EXPLANATION = SUBSTRB(:B2 , 1, 240) WHERE ROWID = :B1 AND ((TRANSACTION_SOURCE_TYPE_ID IN (3, 6, 13 )) OR (TRANSACTION_SOURCE_TYPE_ID > 100 ) ) AND TRANSACTION_ACTION_ID IN (1, 27 ) AND PROCESS_FLAG = 1 AND EXISTS ( SELECT NULL FROM MTL_TRANSACTION_TYPES MTTY WHERE MTTY.TRANSACTION_TYPE_ID = MTI.TRANSACTION_TYPE_ID AND MTTY.TYPE_CLASS = 1 ) AND NOT EXISTS ( SELECT NULL FROM PA_PROJECTS_EXPEND_V PRJ1 WHERE PRJ1.PROJECT_ID = MTI.SOURCE_PROJECT_ID ) |
| f07ydzdqdk3u9 | SELECT NAME FROM RA_BATCH_SOURCES WHERE BATCH_SOURCE_ID = :B1 |
| ga9j9xk5cy9s0 | select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| gash0u2q9atsp | INSERT INTO RA_CUST_TRX_LINE_GL_DIST ( CUST_TRX_LINE_GL_DIST_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, SET_OF_BOOKS_ID, REQUEST_ID, CUSTOMER_TRX_ID, CUSTOMER_TRX_LINE_ID, CUST_TRX_LINE_SALESREP_ID, PERCENT, AMOUNT, ACCTD_AMOUNT, ACCOUNT_CLASS, ACCOUNT_SET_FLAG, CONCATENATED_SEGMENTS, CODE_COMBINATION_ID, GL_DATE, ORIGINAL_GL_DATE, USSGL_TRANSACTION_CODE, USSGL_TRANSACTION_CODE_CONTEXT, POSTING_CONTROL_ID, LATEST_REC_FLAG, COLLECTED_TAX_CONCAT_SEG, COLLECTED_TAX_CCID, REC_OFFSET_FLAG , ORG_ID ) VALUES ( RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL, :B33 , SYSDATE, :B33 , SYSDATE, :B32 , :B31 , :B1 , :B2 , :B3 , ROUND(NVL(:B4 , 0), 4), DECODE(:B5 , 'Y', NULL, :B6 ), DECODE(:B7 , 'Y', NULL, :B8 ), :B9 , :B10 , DECODE(:B11 , '', DECODE(:B12 , -1, :B13 , NULL ), -1, :B14 , NULL), DECODE(:B15 , '', :B16 , :B17 ), TO_DATE(:B18 , 'J'), TO_DATE(:B19 , 'J'), :B20 , :B21 , -3, DECODE( :B22 , 'REC', 'Y', NULL), DECODE(:B23 , '', NULL, DECODE(:B24 , -1, :B25 , NULL)), DECODE(:B26 , '', NULL, :B27 ), DECODE(:B28 , 'Y', NULL, DECODE(:B29 , 'UNEARN', 'Y', NULL)) , :B30 ) RETURNING CUST_TRX_LINE_GL_DIST_ID INTO :O0 |
| gxx5fj67t61nb | SELECT CSI_II_FORWARD_SYNC_TEMP_S.CURRVAL FROM DUAL |