DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_TRANSACTION_FLOW_HEADERS

Line 1657: FROM mtl_transaction_flow_headers

1653: -- this is used for later when we get the cost_group_id
1654: l_progress := 100;
1655: SELECT start_org_id
1656: INTO l_start_org_id
1657: FROM mtl_transaction_flow_headers
1658: WHERE header_id = p_trx_flow_header_id;
1659:
1660: l_progress := 110;
1661: IF (l_debug = 1) THEN

Line 1873: FROM mtl_transaction_flow_headers

1869: new_accounting_flag
1870: into l_selling_OU,
1871: l_shipping_OU,
1872: l_new_accounting_flag
1873: FROM mtl_transaction_flow_headers
1874: WHERE header_id = p_trx_flow_header_id;
1875:
1876: l_progress := 210;
1877: IF (l_debug = 1) THEN

Line 3690: FROM mtl_transaction_flow_headers mtfh,

3686: END IF;
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

Line 3775: mtl_transaction_flow_headers mtfh,

3771: BEGIN
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