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

Line 196: FROM po_distributions pod, -- Using single org view PO_DISTRIBUTIONS to support MOAC

192: poh.currency_code currency_code,
193: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
194: poh.rate_type curr_conv_type,
195: pod.rate_date currency_conv_date
196: FROM po_distributions pod, -- Using single org view PO_DISTRIBUTIONS to support MOAC
197: po_line_locations_all poll,
198: po_lines_all pol,
199: po_headers_all poh,
200: po_vendors pov,

Line 295: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC

291: poh.currency_code currency_code,
292: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
293: poh.rate_type curr_conv_type,
294: pod.rate_date currency_conv_date
295: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
296: ,po_line_locations_all poll
297: ,po_lines_all pol
298: ,po_headers_all poh
299: WHERE pol.po_header_id = poh.po_header_id

Line 370: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC

366: poh.currency_code currency_code,
367: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
368: poh.rate_type curr_conv_type,
369: pod.rate_date currency_conv_date
370: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
371: ,po_line_locations_all poll
372: ,po_lines_all pol
373: ,po_headers_all poh
374: ,po_vendors pov

Line 446: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC

442: poh.currency_code currency_code,
443: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
444: poh.rate_type curr_conv_type,
445: pod.rate_date currency_conv_date
446: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
447: ,po_line_locations_all poll
448: ,po_lines_all pol
449: ,po_headers_all poh
450: ,po_vendors pov

Line 526: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC

522: poh.currency_code currency_code,
523: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
524: poh.rate_type curr_conv_type,
525: pod.rate_date currency_conv_date
526: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
527: ,po_line_locations_all poll
528: ,po_lines_all pol
529: ,po_headers_all poh
530: ,mtl_categories_kfv mca

Line 605: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC

601: poh.currency_code currency_code,
602: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
603: poh.rate_type curr_conv_type,
604: pod.rate_date currency_conv_date
605: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
606: ,po_line_locations_all poll
607: ,po_lines_all pol
608: ,po_headers_all poh
609: ,mtl_categories_kfv mca

Line 1446: CURSOR l_po_distributions_csr IS

1442: OR
1443: (transaction_id = p_transaction_id AND p_transaction_id IS NOT NULL))
1444: ORDER BY transaction_date;
1445:
1446: CURSOR l_po_distributions_csr IS
1447: SELECT po_distribution_id,
1448: DECODE (p_service_flag,
1449: 1, amount_ordered - NVL(amount_cancelled, 0),
1450: quantity_ordered - NVL(quantity_cancelled, 0)) distribution_quantity

Line 1451: FROM po_distributions_all

1447: SELECT po_distribution_id,
1448: DECODE (p_service_flag,
1449: 1, amount_ordered - NVL(amount_cancelled, 0),
1450: quantity_ordered - NVL(quantity_cancelled, 0)) distribution_quantity
1451: FROM po_distributions_all
1452: WHERE line_location_id = x_accrual_rec.shipment_id;
1453:
1454: BEGIN
1455:

Line 1526: FOR l_po_distributions IN l_po_distributions_csr LOOP

1522: g_shipment_id := x_accrual_rec.shipment_id;
1523:
1524: -- clear and initialize the pl/sql table for dist_delivered_quantity
1525: g_dist_nqd_tbl.DELETE;
1526: FOR l_po_distributions IN l_po_distributions_csr LOOP
1527: g_dist_nqd_tbl(l_po_distributions.po_distribution_id) := 0;
1528: END LOOP;
1529:
1530: l_stmt_num := 100;

Line 1527: g_dist_nqd_tbl(l_po_distributions.po_distribution_id) := 0;

1523:
1524: -- clear and initialize the pl/sql table for dist_delivered_quantity
1525: g_dist_nqd_tbl.DELETE;
1526: FOR l_po_distributions IN l_po_distributions_csr LOOP
1527: g_dist_nqd_tbl(l_po_distributions.po_distribution_id) := 0;
1528: END LOOP;
1529:
1530: l_stmt_num := 100;
1531: Get_RcvQuantity (

Line 1557: FOR l_po_distributions IN l_po_distributions_csr LOOP

1553:
1554: -- Expected quantity yet to delivered at shipment level,
1555: -- i.e., sum(dist_quantity_ordered - dist_qty_delivered)
1556: l_shipment_remaining_qty := p_shipment_qty;
1557: FOR l_po_distributions IN l_po_distributions_csr LOOP
1558: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1559: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1560: ELSE
1561: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;

Line 1558: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN

1554: -- Expected quantity yet to delivered at shipment level,
1555: -- i.e., sum(dist_quantity_ordered - dist_qty_delivered)
1556: l_shipment_remaining_qty := p_shipment_qty;
1557: FOR l_po_distributions IN l_po_distributions_csr LOOP
1558: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1559: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1560: ELSE
1561: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;
1562: END IF;

Line 1559: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);

1555: -- i.e., sum(dist_quantity_ordered - dist_qty_delivered)
1556: l_shipment_remaining_qty := p_shipment_qty;
1557: FOR l_po_distributions IN l_po_distributions_csr LOOP
1558: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1559: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1560: ELSE
1561: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;
1562: END IF;
1563: END LOOP;

Line 1561: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;

1557: FOR l_po_distributions IN l_po_distributions_csr LOOP
1558: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1559: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1560: ELSE
1561: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;
1562: END IF;
1563: END LOOP;
1564:
1565: -- Remaining (or expected) quantity to be delivered against this distributions

Line 1687: FOR l_po_distributions IN l_po_distributions_csr LOOP

1683: l_last_rcv_shipment_id := l_transaction_rec.shipment_header_id ;
1684:
1685: -- clear the pl/sql table for distribution_delivered_quantity
1686: g_dist_nqd_tbl.DELETE;
1687: FOR l_po_distributions IN l_po_distributions_csr LOOP
1688: g_dist_nqd_tbl(l_po_distributions.po_distribution_id) := 0;
1689: END LOOP;
1690:
1691: -----------------------------------------------------------------

Line 1688: g_dist_nqd_tbl(l_po_distributions.po_distribution_id) := 0;

1684:
1685: -- clear the pl/sql table for distribution_delivered_quantity
1686: g_dist_nqd_tbl.DELETE;
1687: FOR l_po_distributions IN l_po_distributions_csr LOOP
1688: g_dist_nqd_tbl(l_po_distributions.po_distribution_id) := 0;
1689: END LOOP;
1690:
1691: -----------------------------------------------------------------
1692: -- get net_quantity_received and net_quantity_delivered against

Line 1727: FOR l_po_distributions IN l_po_distributions_csr LOOP

1723:
1724: -- Expected quantity yet to delivered at shipment level,
1725: -- i.e., sum(dist_quantity_ordered - dist_qty_delivered)
1726: l_shipment_remaining_qty := p_shipment_qty;
1727: FOR l_po_distributions IN l_po_distributions_csr LOOP
1728: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1729: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1730: ELSE
1731: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;

Line 1728: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN

1724: -- Expected quantity yet to delivered at shipment level,
1725: -- i.e., sum(dist_quantity_ordered - dist_qty_delivered)
1726: l_shipment_remaining_qty := p_shipment_qty;
1727: FOR l_po_distributions IN l_po_distributions_csr LOOP
1728: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1729: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1730: ELSE
1731: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;
1732: END IF;

Line 1729: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);

1725: -- i.e., sum(dist_quantity_ordered - dist_qty_delivered)
1726: l_shipment_remaining_qty := p_shipment_qty;
1727: FOR l_po_distributions IN l_po_distributions_csr LOOP
1728: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1729: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1730: ELSE
1731: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;
1732: END IF;
1733: END LOOP;

Line 1731: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;

1727: FOR l_po_distributions IN l_po_distributions_csr LOOP
1728: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1729: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1730: ELSE
1731: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;
1732: END IF;
1733: END LOOP;
1734:
1735: -- Remaining (or expected) quantity to be delivered against this distributions

Line 2370: -- Get net_quantity_delivered against each po_distributions

2366: -- Sum of net_quantity_delivered
2367: g_nqd := g_nqd + qty_delivered;
2368:
2369: -----------------------------------------------------------------
2370: -- Get net_quantity_delivered against each po_distributions
2371: -----------------------------------------------------------------
2372: IF (l_shipment_rec.po_distribution_id IS NOT NULL) THEN
2373: g_dist_nqd_tbl(l_shipment_rec.po_distribution_id)
2374: := g_dist_nqd_tbl(l_shipment_rec.po_distribution_id) + qty_delivered;

Line 2461: -- Get net_quantity_delivered against each po_distributions

2457: g_nqr := g_nqr + qty_received;
2458: g_nqd := g_nqd + qty_delivered;
2459:
2460: -----------------------------------------------------------------
2461: -- Get net_quantity_delivered against each po_distributions
2462: -----------------------------------------------------------------
2463: IF (l_txn_rec.po_distribution_id IS NOT NULL) THEN
2464: g_dist_nqd_tbl(l_txn_rec.po_distribution_id)
2465: := g_dist_nqd_tbl(l_txn_rec.po_distribution_id) + qty_delivered;

Line 2645: po_distributions_all pod

2641: FROM ap_invoice_distributions_all aida,
2642: ap_invoices_all aia,
2643: po_lines_all pol,
2644: po_line_locations_all poll,
2645: po_distributions_all pod
2646: WHERE aida.po_distribution_id = pod.po_distribution_id
2647: AND (p_rcv_txn_id IS NULL OR aida.rcv_transaction_id = p_rcv_txn_id)
2648: AND aida.line_type_lookup_code NOT IN ('IPV', 'ERV', 'PREPAY')
2649: AND aida.accounting_date <= p_end_date