APPS.RCV_ROI_TRANSACTION dependencies on PO_DISTRIBUTIONS_ALL

Line 2866: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL

2862: ORDER BY NVL(pll.promised_date, pll.need_by_date);
2863:
2864: /***** Bug # 1553154
2865: ***** There was a performance issue since the cursor DISTRIBUTIONS
2866: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
2867: ***** Modified the Select statement so that it will drive through
2868: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
2869: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
2870: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in

Line 2870: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in

2866: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
2867: ***** Modified the Select statement so that it will drive through
2868: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
2869: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
2870: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in
2871: ***** Performance
2872: *****/
2873: CURSOR count_distributions(
2874: header_id NUMBER,

Line 10004: distribution number from po_distributions_all table */

10000: AND (l_num_of_distributions > 1)) THEN --}{
10001:
10002: /* Bug 5354379: {
10003: If the po_distribution_id is populated in RTI, then derive the
10004: distribution number from po_distributions_all table */
10005:
10006: IF ( x_cascaded_table(n).po_distribution_id IS NOT NULL
10007: AND (x_cascaded_table(n).document_distribution_num IS NULL)) THEN
10008:

Line 10358: from po_distributions_all

10354: where line_location_id = x_po_transferrec.po_line_location_id;
10355:
10356: select distribution_num
10357: into l_po_dist_num
10358: from po_distributions_all
10359: where po_distribution_id = x_po_transferrec.po_distribution_id;
10360:
10361: if x_cascaded_table(n).po_release_id is not null then --5439085
10362: select release_num

Line 10652: We should not compare the transaction quantity with the po_distributions_all.ordered_quantity,

10648: asn_debug.put_line('before getting available qty for standard multi distributions deliver ');
10649: END IF;
10650:
10651: /* Bug 5354379:
10652: We should not compare the transaction quantity with the po_distributions_all.ordered_quantity,
10653: because we won't be able to do DELIVER txn for the RECEIVE txns with overreceipt made.
10654: If the RECEIVE txn for that DELIVER txns lies in RT, we have to make use of mtl_supply
10655: to get the AVAILABLE quantity for DELIVER txn.
10656: If the RECEIVE txn for that DELIVER txns lies in RTI, there is no mtl_supply or rcv_supply.

Line 15628: from po_distributions_all

15624:
15625: BEGIN
15626: select deliver_to_person_id
15627: into l_deliver_to_person_id
15628: from po_distributions_all
15629: where po_distribution_id = x_cascaded_table(n).po_distribution_id;
15630:
15631: x_cascaded_table(n).deliver_to_person_id := l_deliver_to_person_id;
15632: IF (g_asn_debug = 'Y') THEN

Line 15649: from po_distributions_all

15645:
15646: BEGIN
15647: select count(po_distribution_id)
15648: into l_distribution_count
15649: from po_distributions_all
15650: where line_location_id = x_cascaded_table(n).po_line_location_id;
15651:
15652: IF (g_asn_debug = 'Y') THEN
15653: asn_debug.put_line('Inside poll not null..l_distribution_count:'||l_distribution_count);

Line 15659: from po_distributions_all

15655:
15656: IF l_distribution_count = 1 THEN
15657: select deliver_to_person_id
15658: into l_deliver_to_person_id
15659: from po_distributions_all
15660: where line_location_id = x_cascaded_table(n).po_line_location_id;
15661:
15662: x_cascaded_table(n).deliver_to_person_id := l_deliver_to_person_id;
15663: IF (g_asn_debug = 'Y') THEN