eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_TRANSACTION_FLOW_LINES

Line 2150: FROM mtl_transaction_flow_lines

2146: -- Pass this TO_ORGANIZATION_ID to get_cogs_acct_for_logical_so()
2147: BEGIN
2148: SELECT to_organization_id
2149: INTO l_ic_to_inv_organization_id
2150: FROM mtl_transaction_flow_lines
2151: WHERE header_id = l_mtl_trx_tbl(1).trx_flow_header_id;
2152: EXCEPTION
2153: WHEN NO_DATA_FOUND THEN
2154: NULL;

Line 3691: mtl_transaction_flow_lines mtfl

3687:
3688: BEGIN
3689: SELECT COUNT(1) into l_count
3690: FROM mtl_transaction_flow_headers mtfh,
3691: mtl_transaction_flow_lines mtfl
3692: WHERE (l_transaction_date BETWEEN p_period_start_date AND
3693: p_period_end_date) AND
3694: mtfh.header_id = deferred_trxs.trx_flow_header_id AND
3695: mtfh.new_accounting_flag = 'Y' AND

Line 3776: mtl_transaction_flow_lines mtfl

3772: SELECT COUNT(1) into l_count
3773: FROM
3774: mtl_material_transactions mmt,
3775: mtl_transaction_flow_headers mtfh,
3776: mtl_transaction_flow_lines mtfl
3777: WHERE (mmt.transaction_date BETWEEN
3778: l_period_start_date AND l_period_end_date) AND
3779: mmt.logical_transactions_created = 2 AND
3780: mmt.trx_flow_header_id = mtfh.header_id AND