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 111: po_distributions POD,

107: l_stmt_num := 10;
108: SELECT decode(RT.po_distribution_id, NULL, RT.amount * (POD.amount_ordered/POLL.amount),RT.amount)
109: INTO l_transaction_amount
110: FROM rcv_transactions RT,
111: po_distributions POD,
112: po_line_locations POLL
113: WHERE RT.transaction_id = p_rcv_accttxn.rcv_transaction_id
114: AND POD.po_distribution_id = p_rcv_accttxn.po_distribution_id
115: AND POLL.line_location_id = p_rcv_accttxn.po_line_location_id;

Line 156: FROM po_distributions POD

152:
153: l_stmt_num := 60;
154: SELECT POD.amount_ordered, POD.amount_delivered
155: INTO l_po_amount_ordered, l_po_amount_delivered
156: FROM po_distributions POD
157: WHERE po_distribution_id = p_rcv_accttxn.po_distribution_id;
158:
159: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
160: l_api_message := substr('l_rcv_txn_type : '||l_rcv_txn_type||

Line 507: po_distributions pod

503: )
504: INTO l_source_doc_quantity
505: FROM rcv_transactions rt,
506: po_line_locations poll,
507: po_distributions pod
508: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
509: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id
510: AND pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
511: ELSIF (p_rcv_accttxn.event_source = 'RETROPRICE')

Line 541: po_distributions pod

537: )
538: INTO l_source_doc_quantity
539: FROM rcv_transactions rt,
540: po_line_locations poll,
541: po_distributions pod
542: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
543: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id
544: AND pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
545: END IF;

Line 572: FROM po_distributions pod

568: l_stmt_num := 80;
569:
570: SELECT pod.quantity_ordered, pod.quantity_delivered
571: INTO l_po_quantity_ordered, l_po_quantity_delivered
572: FROM po_distributions pod
573: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
574:
575: IF g_debug = 'Y'
576: AND fnd_log.level_statement >= fnd_log.g_current_runtime_level

Line 1342: FROM po_distributions pod

1338: SELECT l_non_recoverable_tax / pod.amount_ordered,
1339: l_recoverable_tax / pod.amount_ordered
1340: INTO l_unit_nr_tax,
1341: l_unit_rec_tax
1342: FROM po_distributions pod
1343: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
1344: ELSE
1345: l_stmt_num := 40;
1346:

Line 1351: FROM po_distributions pod

1347: SELECT l_non_recoverable_tax / pod.quantity_ordered,
1348: l_recoverable_tax / pod.quantity_ordered
1349: INTO l_unit_nr_tax,
1350: l_unit_rec_tax
1351: FROM po_distributions pod
1352: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
1353: END IF;
1354: END IF;
1355:

Line 1364: FROM po_distributions pod

1360: SELECT l_old_non_recoverable_tax / pod.quantity_ordered,
1361: l_old_recoverable_tax / pod.quantity_ordered
1362: INTO l_prior_nr_tax,
1363: l_prior_rec_tax
1364: FROM po_distributions pod
1365: WHERE po_distribution_id = p_rcv_accttxn.po_distribution_id;
1366: END IF;
1367:
1368: x_unit_nr_tax := NVL (l_unit_nr_tax, 0);

Line 1872: FROM po_distributions

1868: l_stmt_num := 20;
1869:
1870: SELECT line_location_id
1871: INTO l_po_line_location_id
1872: FROM po_distributions
1873: WHERE po_distribution_id = p_rcv_accttxn.po_distribution_id;
1874:
1875: l_stmt_num := 30;
1876:

Line 1893: FROM po_distributions pod, po_headers poh

1889: SELECT NVL (pod.rate, 1), poh.rate_type,
1890: pod.rate_date
1891: INTO l_currency_conversion_rate, l_currency_conversion_type,
1892: l_currency_conversion_date
1893: FROM po_distributions pod, po_headers poh
1894: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id
1895: AND poh.po_header_id = pod.po_header_id;
1896: ELSE
1897: -- This is also correct for ADJUST transactions where we only create one event

Line 2177: FROM po_distributions pod

2173: pod.budget_account_id
2174: INTO l_pod_accrual_acct_id, l_pod_ccid,
2175: l_dest_pod_ccid,
2176: l_pod_budget_acct_id
2177: FROM po_distributions pod
2178: WHERE pod.po_distribution_id = p_rcv_accttxn.po_distribution_id;
2179:
2180: l_stmt_num := 20;
2181:

Line 2837: FROM po_distributions

2833: l_stmt_num := 10;
2834:
2835: SELECT ussgl_transaction_code
2836: INTO l_ussgl_tc
2837: FROM po_distributions
2838: WHERE po_distribution_id = p_rcv_accttxn.po_distribution_id;
2839: ELSIF (p_rcv_accttxn.event_type_id IN (deliver, return_to_receiving)
2840: )
2841: THEN

Line 3368: po_distributions pod,

3364: l_inv_trx.parent_transaction_flag, l_inv_trx.trx_source_line_id
3365: FROM rcv_transactions rt,
3366: po_lines pol,
3367: po_line_locations poll,
3368: po_distributions pod,
3369: fnd_currencies fc
3370: WHERE rt.transaction_id = p_rcv_accttxn.rcv_transaction_id
3371: AND pol.po_line_id = p_rcv_accttxn.po_line_id
3372: AND poll.line_location_id = p_rcv_accttxn.po_line_location_id

Line 4396: po_distributions pod,

4392: l_rcv_accttxn.transaction_date, l_rcv_accttxn.item_id,
4393: l_rcv_accttxn.source_doc_quantity,
4394: l_rcv_accttxn.source_doc_uom, l_rcv_accttxn.currency_code
4395: FROM ap_invoice_distributions apid,
4396: po_distributions pod,
4397: po_line_locations poll,
4398: po_lines pol,
4399: po_headers poh
4400: WHERE apid.invoice_distribution_id = p_inv_distribution_id

Line 4439: po_distributions pod

4435: FROM rcv_transactions rt,
4436: po_lines pol,
4437: po_line_locations poll,
4438: po_headers poh,
4439: po_distributions pod
4440: WHERE rt.transaction_id = p_rcv_transaction_id
4441: AND poh.po_header_id = rt.po_header_id
4442: AND pol.po_line_id = rt.po_line_id
4443: AND poll.line_location_id = rt.po_line_location_id

Line 5435: CURSOR c_po_distributions_csr (

5431: l_trx_flow_header_id NUMBER;
5432: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
5433: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
5434:
5435: CURSOR c_po_distributions_csr (
5436: p_po_distribution_id NUMBER,
5437: p_po_line_location_id NUMBER
5438: )
5439: IS

Line 5441: FROM po_distributions pod

5437: p_po_line_location_id NUMBER
5438: )
5439: IS
5440: SELECT po_distribution_id, destination_type_code, project_id
5441: FROM po_distributions pod
5442: WHERE pod.po_distribution_id =
5443: NVL (p_po_distribution_id, pod.po_distribution_id)
5444: AND pod.line_location_id = p_po_line_location_id;
5445: BEGIN

Line 5681: FOR rec_pod IN c_po_distributions_csr (l_po_distribution_id,

5677: -- case of Standard Receipt. Hence perform all steps for each applicable distribution.
5678: -- If distribution is not available the quantity will be prorated. Furthermore, if
5679: -- there is a project on any of the distributions, and the destination_type_code is
5680: -- expense, the transaction flow should be ignored for just that distribution.
5681: FOR rec_pod IN c_po_distributions_csr (l_po_distribution_id,
5682: l_po_line_location_id
5683: )
5684: LOOP
5685: l_stmt_num := 60;

Line 6291: po_distributions pod,

6287: l_accrual_flag
6288: FROM po_headers poh,
6289: po_line_locations poll,
6290: po_lines pol,
6291: po_distributions pod,
6292: rcv_transactions rt
6293: WHERE rt.transaction_id = p_rcv_transaction_id
6294: AND poh.po_header_id = rt.po_header_id
6295: AND poll.line_location_id = rt.po_line_location_id

Line 6828: po_distributions pod,

6824: l_accrual_flag
6825: FROM po_headers poh,
6826: po_line_locations poll,
6827: po_lines pol,
6828: po_distributions pod,
6829: rcv_transactions rt
6830: WHERE rt.transaction_id = p_rcv_transaction_id
6831: AND poh.po_header_id = rt.po_header_id
6832: AND poll.line_location_id = rt.po_line_location_id

Line 7399: CURSOR c_po_distributions_csr (

7395: l_trx_flow_header_id NUMBER;
7396: l_qualifier_code_tbl inv_transaction_flow_pub.number_tbl;
7397: l_qualifier_value_tbl inv_transaction_flow_pub.number_tbl;
7398:
7399: CURSOR c_po_distributions_csr (
7400: p_po_distribution_id NUMBER,
7401: p_po_line_location_id NUMBER
7402: )
7403: IS

Line 7405: FROM po_distributions pod

7401: p_po_line_location_id NUMBER
7402: )
7403: IS
7404: SELECT po_distribution_id, destination_type_code, project_id
7405: FROM po_distributions pod
7406: WHERE pod.po_distribution_id =
7407: NVL (p_po_distribution_id, pod.po_distribution_id)
7408: AND pod.line_location_id = p_po_line_location_id;
7409: BEGIN

Line 7632: FOR rec_pod IN c_po_distributions_csr (l_po_distribution_id,

7628: -- case of Standard Receipt. Hence perform all steps for each applicable distribution.
7629: -- If distribution is not available the quantity will be prorated. Furthermore, if
7630: -- there is a project on any of the distributions, and the destination_type_code is
7631: -- expense, the transaction flow should be ignored for just that distribution.
7632: FOR rec_pod IN c_po_distributions_csr (l_po_distribution_id,
7633: l_po_line_location_id
7634: )
7635: LOOP
7636: l_stmt_num := 50;

Line 8516: FROM po_distributions pod,

8512: -- The PO line location corresponds to the parent rcv_transaction
8513: CURSOR c_po_dists_csr (l_rcv_txn IN NUMBER)
8514: IS
8515: SELECT pod.po_distribution_id
8516: FROM po_distributions pod,
8517: po_line_locations poll,
8518: rcv_transactions rt
8519: WHERE pod.line_location_id = poll.line_location_id
8520: AND poll.line_location_id = rt.po_line_location_id