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 298: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC

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

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

372: poh.currency_code currency_code,
373: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
374: poh.rate_type curr_conv_type,
375: pod.rate_date currency_conv_date
376: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
377: ,po_line_locations_all poll
378: ,po_lines_all pol
379: ,po_headers_all poh
380: ,po_vendors pov

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

451: poh.currency_code currency_code,
452: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
453: poh.rate_type curr_conv_type,
454: pod.rate_date currency_conv_date
455: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
456: ,po_line_locations_all poll
457: ,po_lines_all pol
458: ,po_headers_all poh
459: ,po_vendors pov

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

534: poh.currency_code currency_code,
535: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
536: poh.rate_type curr_conv_type,
537: pod.rate_date currency_conv_date
538: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
539: ,po_line_locations_all poll
540: ,po_lines_all pol
541: ,po_headers_all poh
542: ,mtl_categories_kfv mca

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

616: poh.currency_code currency_code,
617: NVL(NVL(pod.rate,poh.rate),1) currency_rate,
618: poh.rate_type curr_conv_type,
619: pod.rate_date currency_conv_date
620: FROM po_distributions pod -- Using single org view PO_DISTRIBUTIONS to support MOAC
621: ,po_line_locations_all poll
622: ,po_lines_all pol
623: ,po_headers_all poh
624: ,mtl_categories_kfv mca

Line 1465: CURSOR l_po_distributions_csr IS

1461: OR
1462: (transaction_id = p_transaction_id AND p_transaction_id IS NOT NULL))
1463: ORDER BY shipment_header_id, transaction_date;
1464:
1465: CURSOR l_po_distributions_csr IS
1466: SELECT po_distribution_id,
1467: DECODE (p_service_flag,
1468: 1, amount_ordered - NVL(amount_cancelled, 0),
1469: quantity_ordered - NVL(quantity_cancelled, 0)) distribution_quantity

Line 1470: FROM po_distributions_all

1466: SELECT po_distribution_id,
1467: DECODE (p_service_flag,
1468: 1, amount_ordered - NVL(amount_cancelled, 0),
1469: quantity_ordered - NVL(quantity_cancelled, 0)) distribution_quantity
1470: FROM po_distributions_all
1471: WHERE line_location_id = x_accrual_rec.shipment_id;
1472:
1473: BEGIN
1474:

Line 1560: FOR l_po_distributions IN l_po_distributions_csr LOOP

1556: END IF;
1557:
1558: -- clear and initialize the pl/sql table for dist_delivered_quantity
1559: g_dist_nqd_tbl.DELETE;
1560: FOR l_po_distributions IN l_po_distributions_csr LOOP
1561: g_dist_nqd_tbl(l_po_distributions.po_distribution_id) := 0;
1562: END LOOP;
1563:
1564: l_stmt_num := 100;

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

1557:
1558: -- clear and initialize the pl/sql table for dist_delivered_quantity
1559: g_dist_nqd_tbl.DELETE;
1560: FOR l_po_distributions IN l_po_distributions_csr LOOP
1561: g_dist_nqd_tbl(l_po_distributions.po_distribution_id) := 0;
1562: END LOOP;
1563:
1564: l_stmt_num := 100;
1565: Get_RcvQuantity (

Line 1618: FOR l_po_distributions IN l_po_distributions_csr LOOP

1614:
1615: -- Expected quantity yet to delivered at shipment level,
1616: -- i.e., sum(dist_quantity_ordered - dist_qty_delivered)
1617: l_shipment_remaining_qty := p_shipment_qty;
1618: FOR l_po_distributions IN l_po_distributions_csr LOOP
1619: IF (l_pLog) THEN
1620: FND_LOG.STRING(
1621: FND_LOG.LEVEL_PROCEDURE,
1622: l_module||',',

Line 1623: ' l_po_distributions.po_distribution_id is '||l_po_distributions.po_distribution_id ||','||

1619: IF (l_pLog) THEN
1620: FND_LOG.STRING(
1621: FND_LOG.LEVEL_PROCEDURE,
1622: l_module||',',
1623: ' l_po_distributions.po_distribution_id is '||l_po_distributions.po_distribution_id ||','||
1624: 'g_dist_nqd_tbl(l_po_distributions.po_distribution_id) qty is '|| g_dist_nqd_tbl(l_po_distributions.po_distribution_id)
1625: );
1626: END IF;
1627:

Line 1624: 'g_dist_nqd_tbl(l_po_distributions.po_distribution_id) qty is '|| g_dist_nqd_tbl(l_po_distributions.po_distribution_id)

1620: FND_LOG.STRING(
1621: FND_LOG.LEVEL_PROCEDURE,
1622: l_module||',',
1623: ' l_po_distributions.po_distribution_id is '||l_po_distributions.po_distribution_id ||','||
1624: 'g_dist_nqd_tbl(l_po_distributions.po_distribution_id) qty is '|| g_dist_nqd_tbl(l_po_distributions.po_distribution_id)
1625: );
1626: END IF;
1627:
1628: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN

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

1624: 'g_dist_nqd_tbl(l_po_distributions.po_distribution_id) qty is '|| g_dist_nqd_tbl(l_po_distributions.po_distribution_id)
1625: );
1626: END IF;
1627:
1628: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1629: IF (l_pLog) THEN
1630: FND_LOG.STRING(
1631: FND_LOG.LEVEL_PROCEDURE,
1632: l_module||',',

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

1633: ' Inside if'
1634: );
1635: END IF;
1636:
1637: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1638:
1639: ELSE
1640: IF (l_pLog) THEN
1641: FND_LOG.STRING(

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

1643: l_module||',',
1644: ' Inside else'
1645: );
1646: END IF;
1647: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;
1648: END IF;
1649: END LOOP;
1650:
1651: -- Remaining (or expected) quantity to be delivered against this distributions

Line 1791: FOR l_po_distributions IN l_po_distributions_csr LOOP

1787: l_last_rcv_shipment_id := l_transaction_rec.shipment_header_id ;
1788:
1789: -- clear the pl/sql table for distribution_delivered_quantity
1790: g_dist_nqd_tbl.DELETE;
1791: FOR l_po_distributions IN l_po_distributions_csr LOOP
1792: g_dist_nqd_tbl(l_po_distributions.po_distribution_id) := 0;
1793: END LOOP;
1794:
1795: -----------------------------------------------------------------

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

1788:
1789: -- clear the pl/sql table for distribution_delivered_quantity
1790: g_dist_nqd_tbl.DELETE;
1791: FOR l_po_distributions IN l_po_distributions_csr LOOP
1792: g_dist_nqd_tbl(l_po_distributions.po_distribution_id) := 0;
1793: END LOOP;
1794:
1795: -----------------------------------------------------------------
1796: -- get net_quantity_received and net_quantity_delivered against

Line 1828: FOR l_po_distributions IN l_po_distributions_csr LOOP

1824: g_shipment_net_qty_received := g_shipment_net_qty_received + l_txn_net_qty_received;
1825: g_shipment_net_qty_delivered:= g_shipment_net_qty_delivered + l_txn_net_qty_delivered;
1826: g_dist_net_qty_delivered := g_dist_net_qty_delivered + l_dist_qty_delivered;
1827:
1828: FOR l_po_distributions IN l_po_distributions_csr LOOP
1829: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1830: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1831: ELSE
1832: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;

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

1825: g_shipment_net_qty_delivered:= g_shipment_net_qty_delivered + l_txn_net_qty_delivered;
1826: g_dist_net_qty_delivered := g_dist_net_qty_delivered + l_dist_qty_delivered;
1827:
1828: FOR l_po_distributions IN l_po_distributions_csr LOOP
1829: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1830: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1831: ELSE
1832: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;
1833: END IF;

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

1826: g_dist_net_qty_delivered := g_dist_net_qty_delivered + l_dist_qty_delivered;
1827:
1828: FOR l_po_distributions IN l_po_distributions_csr LOOP
1829: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1830: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1831: ELSE
1832: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;
1833: END IF;
1834: END LOOP;

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

1828: FOR l_po_distributions IN l_po_distributions_csr LOOP
1829: IF (l_po_distributions.distribution_quantity > g_dist_nqd_tbl(l_po_distributions.po_distribution_id)) THEN
1830: l_shipment_remaining_qty := l_shipment_remaining_qty - g_dist_nqd_tbl(l_po_distributions.po_distribution_id);
1831: ELSE
1832: l_shipment_remaining_qty := l_shipment_remaining_qty - l_po_distributions.distribution_quantity;
1833: END IF;
1834: END LOOP;
1835:
1836: -----------------------------------------------------------------

Line 2480: -- Get net_quantity_delivered against each po_distributions

2476: -- Sum of net_quantity_delivered
2477: g_nqd := g_nqd + qty_delivered;
2478:
2479: -----------------------------------------------------------------
2480: -- Get net_quantity_delivered against each po_distributions
2481: -----------------------------------------------------------------
2482: IF (l_shipment_rec.po_distribution_id IS NOT NULL) THEN
2483: g_dist_nqd_tbl(l_shipment_rec.po_distribution_id)
2484: := g_dist_nqd_tbl(l_shipment_rec.po_distribution_id) + qty_delivered;

Line 2571: -- Get net_quantity_delivered against each po_distributions

2567: g_nqr := g_nqr + qty_received;
2568: g_nqd := g_nqd + qty_delivered;
2569:
2570: -----------------------------------------------------------------
2571: -- Get net_quantity_delivered against each po_distributions
2572: -----------------------------------------------------------------
2573: IF (l_txn_rec.po_distribution_id IS NOT NULL) THEN
2574: g_dist_nqd_tbl(l_txn_rec.po_distribution_id)
2575: := g_dist_nqd_tbl(l_txn_rec.po_distribution_id) + qty_delivered;

Line 2760: po_distributions_all pod

2756: FROM ap_invoice_distributions_all aida,
2757: ap_invoices_all aia,
2758: po_lines_all pol,
2759: po_line_locations_all poll,
2760: po_distributions_all pod
2761: WHERE aida.po_distribution_id = pod.po_distribution_id
2762: AND (p_rcv_txn_id IS NULL OR aida.rcv_transaction_id = p_rcv_txn_id)
2763: AND aida.line_type_lookup_code NOT IN ('IPV', 'ERV', 'PREPAY','REC_TAX')
2764: AND aida.accounting_date <= p_end_date