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 1773: FROM po_distributions POD

1769: SELECT l_non_recoverable_tax/POD.amount_ordered,
1770: l_recoverable_tax/POD.amount_ordered
1771: INTO l_unit_nr_tax,
1772: l_unit_rec_tax
1773: FROM po_distributions POD
1774: WHERE POD.po_distribution_id = p_rcv_event.po_distribution_id;
1775: ELSE
1776: l_stmt_num := 40;
1777: SELECT l_non_recoverable_tax/POD.quantity_ordered,

Line 1781: FROM po_distributions POD

1777: SELECT l_non_recoverable_tax/POD.quantity_ordered,
1778: l_recoverable_tax/POD.quantity_ordered
1779: INTO l_unit_nr_tax,
1780: l_unit_rec_tax
1781: FROM po_distributions POD
1782: WHERE POD.po_distribution_id = p_rcv_event.po_distribution_id;
1783: END IF;
1784: END IF;
1785:

Line 1792: FROM po_distributions POD

1788: SELECT l_old_non_recoverable_tax/POD.quantity_ordered,
1789: l_old_recoverable_tax/POD.quantity_ordered
1790: INTO l_prior_nr_tax,
1791: l_prior_rec_tax
1792: FROM po_distributions POD
1793: WHERE po_distribution_id = p_rcv_event.po_distribution_id;
1794: END IF;
1795:
1796: x_unit_nr_tax := NVL(l_unit_nr_tax,0);

Line 2236: FROM po_distributions

2232:
2233: l_stmt_num := 20;
2234: SELECT line_location_id
2235: INTO l_po_line_location_id
2236: FROM po_distributions
2237: WHERE po_distribution_id = p_rcv_event.po_distribution_id;
2238:
2239: l_stmt_num := 30;
2240: SELECT match_option

Line 2255: FROM po_distributions POD,

2251: nvl(POD.rate_date,POD.creation_date) /*Changes for bug 8623413 to take creation date in case rate_date is null */
2252: INTO l_currency_conversion_rate,
2253: l_currency_conversion_type,
2254: l_currency_conversion_date
2255: FROM po_distributions POD,
2256: po_headers POH
2257: WHERE POD.po_distribution_id = p_rcv_event.po_distribution_id
2258: AND POH.po_header_id = POD.po_header_id;
2259:

Line 2523: FROM po_distributions POD

2519: INTO l_pod_accrual_acct_id,
2520: l_pod_ccid,
2521: l_dest_pod_ccid,
2522: l_pod_budget_acct_id
2523: FROM po_distributions POD
2524: WHERE POD.po_distribution_id = p_rcv_event.po_distribution_id;
2525:
2526: l_stmt_num := 20;
2527: SELECT receiving_account_id,

Line 4418: po_distributions POD,

4414: l_inv_trx.trx_source_line_id
4415: FROM rcv_transactions RT,
4416: po_lines POL,
4417: po_line_locations POLL,
4418: po_distributions POD,
4419: fnd_currencies FC
4420: WHERE RT.transaction_id = p_rcv_event.rcv_transaction_id
4421: AND POL.po_line_id = p_rcv_event.po_line_id
4422: AND POLL.line_location_id = p_rcv_event.po_line_location_id