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.RCV_ACCEVENTS_PVT dependencies on PO_DISTRIBUTIONS

Line 450: FROM po_distributions POD,

446: -- The PO line location corresponds to the parent rcv_transaction
447:
448: CURSOR c_po_dists_csr (l_rcv_txn IN NUMBER) IS
449: SELECT POD.po_distribution_id
450: FROM po_distributions POD,
451: po_line_locations POLL,
452: rcv_transactions RT
453: WHERE POD.line_location_id = POLL.line_location_id
454: AND POLL.line_location_id = RT.po_line_location_id

Line 1081: CURSOR c_po_distributions_csr(p_po_distribution_id NUMBER, p_po_line_location_id NUMBER) IS

1077:
1078: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1079: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1080:
1081: CURSOR c_po_distributions_csr(p_po_distribution_id NUMBER, p_po_line_location_id NUMBER) IS
1082: SELECT po_distribution_id,destination_type_code, project_id
1083: FROM po_distributions POD
1084: WHERE POD.po_distribution_id = NVL(p_po_distribution_id,POD.po_distribution_id)
1085: AND POD.line_location_id = p_po_line_location_id;

Line 1083: FROM po_distributions POD

1079: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
1080:
1081: CURSOR c_po_distributions_csr(p_po_distribution_id NUMBER, p_po_line_location_id NUMBER) IS
1082: SELECT po_distribution_id,destination_type_code, project_id
1083: FROM po_distributions POD
1084: WHERE POD.po_distribution_id = NVL(p_po_distribution_id,POD.po_distribution_id)
1085: AND POD.line_location_id = p_po_line_location_id;
1086:
1087: BEGIN

Line 1270: FOR rec_pod IN c_po_distributions_csr(l_po_distribution_id, l_po_line_location_id) LOOP

1266: -- case of Standard Receipt. Hence perform all steps for each applicable distribution.
1267: -- If distribution is not available the quantity will be prorated. Furthermore, if
1268: -- there is a project on any of the distributions, and the destination_type_code is
1269: -- expense, the transaction flow should be ignored for just that distribution.
1270: FOR rec_pod IN c_po_distributions_csr(l_po_distribution_id, l_po_line_location_id) LOOP
1271:
1272: l_stmt_num := 60;
1273: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1274: l_api_message := 'Creating Receive Events : '||

Line 1840: po_distributions POD,

1836: l_lcm_flag
1837: FROM po_headers POH,
1838: po_line_locations POLL,
1839: po_lines POL,
1840: po_distributions POD,
1841: rcv_transactions RT
1842: WHERE RT.transaction_id = p_rcv_transaction_id
1843: AND POH.po_header_id = RT.po_header_id
1844: AND POLL.line_location_id = RT.po_line_location_id

Line 2386: po_distributions POD,

2382: l_lcm_flag
2383: FROM po_headers POH,
2384: po_line_locations POLL,
2385: po_lines POL,
2386: po_distributions POD,
2387: rcv_transactions RT
2388: WHERE RT.transaction_id = p_rcv_transaction_id
2389: AND POH.po_header_id = RT.po_header_id
2390: AND POLL.line_location_id = RT.po_line_location_id

Line 2871: CURSOR c_po_distributions_csr(p_po_distribution_id NUMBER, p_po_line_location_id NUMBER) IS

2867:
2868: l_qualifier_code_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2869: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2870:
2871: CURSOR c_po_distributions_csr(p_po_distribution_id NUMBER, p_po_line_location_id NUMBER) IS
2872: SELECT po_distribution_id,destination_type_code, project_id
2873: FROM po_distributions POD
2874: WHERE POD.po_distribution_id = NVL(p_po_distribution_id,POD.po_distribution_id)
2875: AND POD.line_location_id = p_po_line_location_id;

Line 2873: FROM po_distributions POD

2869: l_qualifier_value_tbl INV_TRANSACTION_FLOW_PUB.NUMBER_TBL;
2870:
2871: CURSOR c_po_distributions_csr(p_po_distribution_id NUMBER, p_po_line_location_id NUMBER) IS
2872: SELECT po_distribution_id,destination_type_code, project_id
2873: FROM po_distributions POD
2874: WHERE POD.po_distribution_id = NVL(p_po_distribution_id,POD.po_distribution_id)
2875: AND POD.line_location_id = p_po_line_location_id;
2876:
2877:

Line 3055: FOR rec_pod IN c_po_distributions_csr(l_po_distribution_id, l_po_line_location_id) LOOP

3051: -- case of Standard Receipt. Hence perform all steps for each applicable distribution.
3052: -- If distribution is not available the quantity will be prorated. Furthermore, if
3053: -- there is a project on any of the distributions, and the destination_type_code is
3054: -- expense, the transaction flow should be ignored for just that distribution.
3055: FOR rec_pod IN c_po_distributions_csr(l_po_distribution_id, l_po_line_location_id) LOOP
3056:
3057: l_stmt_num := 50;
3058:
3059: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 3622: po_distributions POD,

3618: l_lcm_flag
3619: FROM po_headers POH,
3620: po_line_locations POLL,
3621: po_lines POL,
3622: po_distributions POD,
3623: rcv_transactions RT
3624: WHERE RT.transaction_id = p_rcv_transaction_id
3625: AND POH.po_header_id = RT.po_header_id
3626: AND POLL.line_location_id = RT.po_line_location_id