DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_TRANSACTION_FLOW_LINES

Line 2167: FROM mtl_transaction_flow_lines

2163: -- Pass this TO_ORGANIZATION_ID to get_cogs_acct_for_logical_so()
2164: BEGIN
2165: SELECT to_organization_id
2166: INTO l_ic_to_inv_organization_id
2167: FROM mtl_transaction_flow_lines
2168: WHERE header_id = l_mtl_trx_tbl(1).trx_flow_header_id;
2169: EXCEPTION
2170: WHEN NO_DATA_FOUND THEN
2171: NULL;

Line 3778: mtl_transaction_flow_lines mtfl

3774:
3775: BEGIN
3776: SELECT COUNT(1) into l_count
3777: FROM mtl_transaction_flow_headers mtfh,
3778: mtl_transaction_flow_lines mtfl
3779: WHERE (l_transaction_date BETWEEN p_period_start_date AND
3780: p_period_end_date) AND
3781: mtfh.header_id = deferred_trxs.trx_flow_header_id AND
3782: mtfh.new_accounting_flag = 'Y' AND

Line 3863: mtl_transaction_flow_lines mtfl

3859: SELECT COUNT(1) into l_count
3860: FROM
3861: mtl_material_transactions mmt,
3862: mtl_transaction_flow_headers mtfh,
3863: mtl_transaction_flow_lines mtfl
3864: WHERE (mmt.transaction_date BETWEEN
3865: l_period_start_date AND l_period_end_date) AND
3866: mmt.logical_transactions_created = 2 AND
3867: mmt.trx_flow_header_id = mtfh.header_id AND