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_SEEDEVENTS_PVT dependencies on PO_DISTRIBUTIONS

Line 236: po_distributions POD,

232: l_rcv_event.source_doc_quantity,
233: l_rcv_event.source_doc_uom,
234: l_rcv_event.currency_code
235: FROM ap_invoice_distributions APID,
236: po_distributions POD,
237: po_line_locations POLL,
238: po_lines POL,
239: po_headers POH
240: WHERE APID.invoice_distribution_id = p_inv_distribution_id

Line 288: po_distributions POD

284: FROM rcv_transactions RT,
285: po_lines POL,
286: po_line_locations POLL,
287: po_headers POH,
288: po_distributions POD
289: WHERE RT.transaction_id = p_rcv_transaction_id
290: AND POH.po_header_id = RT.po_header_id
291: AND POL.po_line_id = RT.po_line_id
292: AND POLL.line_location_id = RT.po_line_location_id

Line 785: po_distributions POD,

781: RT.amount * (POD.amount_ordered/POLL.amount),
782: RT.amount)
783: INTO l_transaction_amount
784: FROM rcv_transactions RT,
785: po_distributions POD,
786: po_line_locations POLL
787: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
788: AND POD.po_distribution_id = p_rcv_event.po_distribution_id
789: AND POLL.line_location_id = p_rcv_event.po_line_location_id;

Line 831: FROM po_distributions POD

827:
828: l_stmt_num := 60;
829: SELECT POD.amount_ordered, POD.amount_delivered
830: INTO l_po_amount_ordered, l_po_amount_delivered
831: FROM po_distributions POD
832: WHERE po_distribution_id = p_rcv_event.po_distribution_id;
833:
834: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
835: l_api_message := substr('l_rcv_txn_type : '||l_rcv_txn_type||

Line 1039: po_distributions POD

1035: RT.source_doc_quantity)
1036: INTO l_source_doc_quantity
1037: FROM rcv_transactions RT,
1038: po_line_locations POLL,
1039: po_distributions POD
1040: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
1041: AND POLL.line_location_id = p_rcv_event.po_line_location_id
1042: AND POD.po_distribution_id = p_rcv_event.po_distribution_id;
1043:

Line 1060: po_distributions POD

1056: l_source_doc_quantity)
1057: INTO l_source_doc_quantity
1058: FROM rcv_transactions RT,
1059: po_line_locations POLL,
1060: po_distributions POD
1061: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
1062: AND POLL.line_location_id = p_rcv_event.po_line_location_id
1063: AND POD.po_distribution_id = p_rcv_event.po_distribution_id;
1064: END IF;

Line 1089: FROM po_distributions POD

1085:
1086: l_stmt_num := 80;
1087: SELECT POD.quantity_ordered, POD.quantity_delivered
1088: INTO l_po_quantity_ordered, l_po_quantity_delivered
1089: FROM po_distributions POD
1090: WHERE POD.po_distribution_id = p_rcv_event.po_distribution_id;
1091:
1092: IF G_DEBUG = 'Y' AND FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1093: l_api_message := SUBSTR('l_rcv_txn_type : '||l_rcv_txn_type||

Line 1766: FROM po_distributions POD

1762: SELECT l_non_recoverable_tax/POD.amount_ordered,
1763: l_recoverable_tax/POD.amount_ordered
1764: INTO l_unit_nr_tax,
1765: l_unit_rec_tax
1766: FROM po_distributions POD
1767: WHERE POD.po_distribution_id = p_rcv_event.po_distribution_id;
1768: ELSE
1769: l_stmt_num := 40;
1770: SELECT l_non_recoverable_tax/POD.quantity_ordered,

Line 1774: FROM po_distributions POD

1770: SELECT l_non_recoverable_tax/POD.quantity_ordered,
1771: l_recoverable_tax/POD.quantity_ordered
1772: INTO l_unit_nr_tax,
1773: l_unit_rec_tax
1774: FROM po_distributions POD
1775: WHERE POD.po_distribution_id = p_rcv_event.po_distribution_id;
1776: END IF;
1777: END IF;
1778:

Line 1785: FROM po_distributions POD

1781: SELECT l_old_non_recoverable_tax/POD.quantity_ordered,
1782: l_old_recoverable_tax/POD.quantity_ordered
1783: INTO l_prior_nr_tax,
1784: l_prior_rec_tax
1785: FROM po_distributions POD
1786: WHERE po_distribution_id = p_rcv_event.po_distribution_id;
1787: END IF;
1788:
1789: x_unit_nr_tax := NVL(l_unit_nr_tax,0);

Line 2229: FROM po_distributions

2225:
2226: l_stmt_num := 20;
2227: SELECT line_location_id
2228: INTO l_po_line_location_id
2229: FROM po_distributions
2230: WHERE po_distribution_id = p_rcv_event.po_distribution_id;
2231:
2232: l_stmt_num := 30;
2233: SELECT match_option

Line 2248: FROM po_distributions POD,

2244: POD.rate_date
2245: INTO l_currency_conversion_rate,
2246: l_currency_conversion_type,
2247: l_currency_conversion_date
2248: FROM po_distributions POD,
2249: po_headers POH
2250: WHERE POD.po_distribution_id = p_rcv_event.po_distribution_id
2251: AND POH.po_header_id = POD.po_header_id;
2252:

Line 2516: FROM po_distributions POD

2512: INTO l_pod_accrual_acct_id,
2513: l_pod_ccid,
2514: l_dest_pod_ccid,
2515: l_pod_budget_acct_id
2516: FROM po_distributions POD
2517: WHERE POD.po_distribution_id = p_rcv_event.po_distribution_id;
2518:
2519: l_stmt_num := 20;
2520: SELECT receiving_account_id,

Line 4409: po_distributions POD,

4405: l_inv_trx.trx_source_line_id
4406: FROM rcv_transactions RT,
4407: po_lines POL,
4408: po_line_locations POLL,
4409: po_distributions POD,
4410: fnd_currencies FC
4411: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
4412: AND POL.po_line_id = p_rcv_event.po_line_id
4413: AND POLL.line_location_id = p_rcv_event.po_line_location_id