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

Line 117: po_distributions POD,

113: l_stmt_num := 10;
114: SELECT decode(RT.po_distribution_id, NULL, RT.amount * (POD.amount_ordered/POLL.amount),RT.amount)
115: INTO l_transaction_amount
116: FROM rcv_transactions RT,
117: po_distributions POD,
118: po_line_locations POLL
119: WHERE RT.transaction_id = p_rcv_accttxn.rcv_transaction_id
120: AND POD.po_distribution_id = p_rcv_accttxn.po_distribution_id
121: AND POLL.line_location_id = p_rcv_accttxn.po_line_location_id;

Line 162: FROM po_distributions POD

158:
159: l_stmt_num := 60;
160: SELECT POD.amount_ordered, POD.amount_delivered
161: INTO l_po_amount_ordered, l_po_amount_delivered
162: FROM po_distributions POD
163: WHERE po_distribution_id = p_rcv_accttxn.po_distribution_id;
164:
165: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
166: l_api_message := substr('l_rcv_txn_type : '||l_rcv_txn_type||

Line 513: po_distributions pod

509: )
510: INTO l_source_doc_quantity
511: FROM rcv_transactions rt,
512: po_line_locations poll,
513: po_distributions pod
514: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
515: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id
516: AND pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
517: ELSIF (p_rcv_accttxn.event_source = 'RETROPRICE')

Line 547: po_distributions pod

543: )
544: INTO l_source_doc_quantity
545: FROM rcv_transactions rt,
546: po_line_locations poll,
547: po_distributions pod
548: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
549: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id
550: AND pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
551: END IF;

Line 578: FROM po_distributions pod

574: l_stmt_num := 80;
575:
576: SELECT pod.quantity_ordered, pod.quantity_delivered
577: INTO l_po_quantity_ordered, l_po_quantity_delivered
578: FROM po_distributions pod
579: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
580:
581: IF g_debug = 'Y'
582: AND fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 1348: FROM po_distributions pod

1344: SELECT l_non_recoverable_tax / pod.amount_ordered,
1345: l_recoverable_tax / pod.amount_ordered
1346: INTO l_unit_nr_tax,
1347: l_unit_rec_tax
1348: FROM po_distributions pod
1349: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
1350: ELSE
1351: l_stmt_num := 40;
1352:

Line 1357: FROM po_distributions pod

1353: SELECT l_non_recoverable_tax / pod.quantity_ordered,
1354: l_recoverable_tax / pod.quantity_ordered
1355: INTO l_unit_nr_tax,
1356: l_unit_rec_tax
1357: FROM po_distributions pod
1358: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
1359: END IF;
1360: END IF;
1361:

Line 1370: FROM po_distributions pod

1366: SELECT l_old_non_recoverable_tax / pod.quantity_ordered,
1367: l_old_recoverable_tax / pod.quantity_ordered
1368: INTO l_prior_nr_tax,
1369: l_prior_rec_tax
1370: FROM po_distributions pod
1371: WHERE po_distribution_id = p_rcv_accttxn.po_distribution_id;
1372: END IF;
1373:
1374: x_unit_nr_tax := NVL (l_unit_nr_tax, 0);

Line 1878: FROM po_distributions

1874: l_stmt_num := 20;
1875:
1876: SELECT line_location_id
1877: INTO l_po_line_location_id
1878: FROM po_distributions
1879: WHERE po_distribution_id = p_rcv_accttxn.po_distribution_id;
1880:
1881: l_stmt_num := 30;
1882:

Line 1899: FROM po_distributions pod, po_headers poh

1895: SELECT NVL (pod.rate, 1), poh.rate_type,
1896: pod.rate_date
1897: INTO l_currency_conversion_rate, l_currency_conversion_type,
1898: l_currency_conversion_date
1899: FROM po_distributions pod, po_headers poh
1900: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id
1901: AND poh.po_header_id = pod.po_header_id;
1902: ELSE
1903: -- This is also correct for ADJUST transactions where we only create one event

Line 2183: FROM po_distributions pod

2179: pod.budget_account_id
2180: INTO l_pod_accrual_acct_id, l_pod_ccid,
2181: l_dest_pod_ccid,
2182: l_pod_budget_acct_id
2183: FROM po_distributions pod
2184: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
2185:
2186: l_stmt_num := 20;
2187:

Line 2843: FROM po_distributions

2839: l_stmt_num := 10;
2840:
2841: SELECT ussgl_transaction_code
2842: INTO l_ussgl_tc
2843: FROM po_distributions
2844: WHERE po_distribution_id = p_rcv_accttxn.po_distribution_id;
2845: ELSIF (p_rcv_accttxn.event_type_id IN (deliver, return_to_receiving)
2846: )
2847: THEN

Line 3374: po_distributions pod,

3370: l_inv_trx.parent_transaction_flag, l_inv_trx.trx_source_line_id
3371: FROM rcv_transactions rt,
3372: po_lines pol,
3373: po_line_locations poll,
3374: po_distributions pod,
3375: fnd_currencies fc
3376: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
3377: AND pol.po_line_id = p_rcv_accttxn.po_line_id
3378: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id

Line 4402: po_distributions pod,

4398: l_rcv_accttxn.transaction_date, l_rcv_accttxn.item_id,
4399: l_rcv_accttxn.source_doc_quantity,
4400: l_rcv_accttxn.source_doc_uom, l_rcv_accttxn.currency_code
4401: FROM ap_invoice_distributions apid,
4402: po_distributions pod,
4403: po_line_locations poll,
4404: po_lines pol,
4405: po_headers poh
4406: WHERE apid.invoice_distribution_id = p_inv_distribution_id

Line 4451: po_distributions pod

4447: FROM rcv_transactions rt,
4448: po_lines pol,
4449: po_line_locations poll,
4450: po_headers poh,
4451: po_distributions pod
4452: WHERE rt.transaction_id = p_rcv_transaction_id
4453: AND poh.po_header_id = rt.po_header_id
4454: AND pol.po_line_id = rt.po_line_id
4455: AND poll.line_location_id = rt.po_line_location_id

Line 5453: CURSOR c_po_distributions_csr (

5449: l_trx_flow_header_id NUMBER;
5450: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
5451: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
5452:
5453: CURSOR c_po_distributions_csr (
5454: p_po_distribution_id NUMBER,
5455: p_po_line_location_id NUMBER
5456: )
5457: IS

Line 5459: FROM po_distributions pod

5455: p_po_line_location_id NUMBER
5456: )
5457: IS
5458: SELECT po_distribution_id, destination_type_code, project_id
5459: FROM po_distributions pod
5460: WHERE pod.po_distribution_id =
5461: NVL (p_po_distribution_id, pod.po_distribution_id)
5462: AND pod.line_location_id = p_po_line_location_id;
5463: BEGIN

Line 5699: FOR rec_pod IN c_po_distributions_csr (l_po_distribution_id,

5695: -- case of Standard Receipt. Hence perform all steps for each applicable distribution.
5696: -- If distribution is not available the quantity will be prorated. Furthermore, if
5697: -- there is a project on any of the distributions, and the destination_type_code is
5698: -- expense, the transaction flow should be ignored for just that distribution.
5699: FOR rec_pod IN c_po_distributions_csr (l_po_distribution_id,
5700: l_po_line_location_id
5701: )
5702: LOOP
5703: l_stmt_num := 60;

Line 6312: po_distributions pod,

6308: l_accrual_flag
6309: FROM po_headers poh,
6310: po_line_locations poll,
6311: po_lines pol,
6312: po_distributions pod,
6313: rcv_transactions rt
6314: WHERE rt.transaction_id = p_rcv_transaction_id
6315: AND poh.po_header_id = rt.po_header_id
6316: AND poll.line_location_id = rt.po_line_location_id

Line 6883: po_distributions pod,

6879: l_accrual_flag
6880: FROM po_headers poh,
6881: po_line_locations poll,
6882: po_lines pol,
6883: po_distributions pod,
6884: rcv_transactions rt
6885: WHERE rt.transaction_id = p_rcv_transaction_id
6886: AND poh.po_header_id = rt.po_header_id
6887: AND poll.line_location_id = rt.po_line_location_id

Line 7454: CURSOR c_po_distributions_csr (

7450: l_trx_flow_header_id NUMBER;
7451: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
7452: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
7453:
7454: CURSOR c_po_distributions_csr (
7455: p_po_distribution_id NUMBER,
7456: p_po_line_location_id NUMBER
7457: )
7458: IS

Line 7460: FROM po_distributions pod

7456: p_po_line_location_id NUMBER
7457: )
7458: IS
7459: SELECT po_distribution_id, destination_type_code, project_id
7460: FROM po_distributions pod
7461: WHERE pod.po_distribution_id =
7462: NVL (p_po_distribution_id, pod.po_distribution_id)
7463: AND pod.line_location_id = p_po_line_location_id;
7464: BEGIN

Line 7687: FOR rec_pod IN c_po_distributions_csr (l_po_distribution_id,

7683: -- case of Standard Receipt. Hence perform all steps for each applicable distribution.
7684: -- If distribution is not available the quantity will be prorated. Furthermore, if
7685: -- there is a project on any of the distributions, and the destination_type_code is
7686: -- expense, the transaction flow should be ignored for just that distribution.
7687: FOR rec_pod IN c_po_distributions_csr (l_po_distribution_id,
7688: l_po_line_location_id
7689: )
7690: LOOP
7691: l_stmt_num := 50;

Line 8574: FROM po_distributions pod,

8570: -- The PO line location corresponds to the parent rcv_transaction
8571: CURSOR c_po_dists_csr (l_rcv_txn IN NUMBER)
8572: IS
8573: SELECT pod.po_distribution_id
8574: FROM po_distributions pod,
8575: po_line_locations poll,
8576: rcv_transactions rt
8577: WHERE pod.line_location_id = poll.line_location_id
8578: AND poll.line_location_id = rt.po_line_location_id