DBA Data[Home] [Help]

APPS.CST_REVENUECOGSMATCH_PVT dependencies on MTL_TRANSACTION_ACCOUNTS

Line 4406: INSERT INTO mtl_transaction_accounts mta (

4402: -- The following statement will create elemental distributions for all source rows returned
4403: -- by the above cursor.
4404: l_stmt_num := 30;
4405: FORALL i IN l_event_id_tbl.FIRST..l_event_id_tbl.LAST
4406: INSERT INTO mtl_transaction_accounts mta (
4407: TRANSACTION_ID,
4408: REFERENCE_ACCOUNT,
4409: INVENTORY_ITEM_ID,
4410: ORGANIZATION_ID,

Line 4565: FROM mtl_transaction_accounts mta

4561: AND pop.organization_id (+) = mp.organization_id
4562: AND NVL(pop.pa_posting_flag,'N') <> 'Y'
4563:
4564: AND EXISTS (SELECT NULL
4565: FROM mtl_transaction_accounts mta
4566: WHERE mta.transaction_id = mmt.transaction_id);
4567:
4568:
4569: debug('COUNT XLA:'||SQL%ROWCOUNT);

Line 6093: MTL_TRANSACTION_ACCOUNTS MTA

6089: CST_COGS_EVENTS CCE,
6090: GL_PERIOD_STATUSES GPS,
6091: OE_ORDER_LINES_ALL OOL,
6092: OE_ORDER_HEADERS_ALL OOH,
6093: MTL_TRANSACTION_ACCOUNTS MTA
6094: WHERE
6095: CRCML.SALES_ORDER_ISSUE_DATE BETWEEN :i_sales_order_date_low AND :i_sales_order_date_high
6096: AND CRCML.OPERATING_UNIT_ID = :i_operating_unit
6097: AND CRCML.PAC_COST_TYPE_ID IS NULL

Line 6141: MTL_TRANSACTION_ACCOUNTS MTA

6137: CST_COGS_EVENTS CCE,
6138: GL_PERIOD_STATUSES GPS,
6139: OE_ORDER_LINES_ALL OOL,
6140: OE_ORDER_HEADERS_ALL OOH,
6141: MTL_TRANSACTION_ACCOUNTS MTA
6142: WHERE
6143: CRCML.SALES_ORDER_ISSUE_DATE BETWEEN :i_sales_order_date_low AND :i_sales_order_date_high
6144: AND CRCML.OPERATING_UNIT_ID = :i_operating_unit
6145: AND CRCML.PAC_COST_TYPE_ID IS NULL