DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on MTL_TRANSACTION_FLOW_HEADERS

Line 1674: FROM mtl_transaction_flow_headers

1670: -- this is used for later when we get the cost_group_id
1671: l_progress := 100;
1672: SELECT start_org_id
1673: INTO l_start_org_id
1674: FROM mtl_transaction_flow_headers
1675: WHERE header_id = p_trx_flow_header_id;
1676:
1677: l_progress := 110;
1678: IF (l_debug = 1) THEN

Line 1890: FROM mtl_transaction_flow_headers

1886: new_accounting_flag
1887: into l_selling_OU,
1888: l_shipping_OU,
1889: l_new_accounting_flag
1890: FROM mtl_transaction_flow_headers
1891: WHERE header_id = p_trx_flow_header_id;
1892:
1893: l_progress := 210;
1894: IF (l_debug = 1) THEN

Line 3777: FROM mtl_transaction_flow_headers mtfh,

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

Line 3862: mtl_transaction_flow_headers mtfh,

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