[Home] [Help]
238: pod.ussgl_transaction_code,
239: pll.ship_to_location_id,
240: NVL(pll.enforce_ship_to_location_code, 'NONE') enforce_ship_to_location_code,
241: pl.item_id
242: FROM po_distributions pod,
243: po_line_locations pll,
244: po_lines pl,
245: po_headers ph
246: WHERE ph.po_header_id = header_id
265: ORDER BY NVL(pll.promised_date, pll.need_by_date);
266:
267: /***** Bug # 1553154
268: ***** There was a performance issue since the cursor DISTRIBUTIONS
269: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
270: ***** Modified the Select statement so that it will drive through
271: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
272: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
273: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in
269: ***** was driving through PO_HEADERS_ALL followed by PO_DISTRIBUTIONS_ALL
270: ***** Modified the Select statement so that it will drive through
271: ***** PO_HEADERS_ALL followed by PO_LINES_ALL which is followed by
272: ***** PO_LINE_LOCATIONS_ALL which in turn is followed by
273: ***** PO_DISTRIBUTIONS_ALL so that there is an improvement in
274: ***** Performance
275: *****/
276: CURSOR count_distributions(
277: header_id NUMBER,
284: v_ship_to_location_id NUMBER,
285: v_vendor_product_num VARCHAR2
286: ) IS
287: SELECT COUNT(*)
288: FROM po_distributions pod,
289: po_line_locations pll,
290: po_lines pl,
291: po_headers ph
292: WHERE ph.po_header_id = header_id
1251: AND temp_cascaded_table(current_n).po_distribution_id IS NOT NULL THEN
1252: BEGIN
1253: SELECT distribution_num
1254: INTO temp_cascaded_table(current_n).document_distribution_num
1255: FROM po_distributions
1256: WHERE po_distribution_id = temp_cascaded_table(current_n).po_distribution_id;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: IF (g_asn_debug = 'Y') THEN
1640: no shipments exists for receiving for the given PO.
1641: */
1642: IF ( x_cascaded_table(n).transaction_type <> 'DELIVER'
1643: AND NVL(x_cascaded_table(n).auto_transact_code, 'RECEIVE') <> 'DELIVER') THEN
1644: -- Bug 2551443 Removed po_distributions from the FROM clause
1645: SELECT COUNT(*)
1646: INTO x_temp_count
1647: FROM po_line_locations pll,
1648: po_lines pl,
1689: ELSIF( x_cascaded_table(n).transaction_type = 'DELIVER'
1690: OR NVL(x_cascaded_table(n).auto_transact_code, 'RECEIVE') = 'DELIVER') THEN
1691: SELECT COUNT(*)
1692: INTO x_temp_count
1693: FROM po_distributions pod,
1694: po_line_locations pll,
1695: po_lines pl,
1696: po_headers ph
1697: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
1724: x_shipment_type,
1725: x_ship_to_organization_id,
1726: x_ship_to_location_id,
1727: x_vendor_product_num
1728: FROM po_distributions pod,
1729: po_line_locations pll,
1730: po_lines pl,
1731: po_headers ph
1732: WHERE ph.po_header_id = temp_cascaded_table(current_n).po_header_id
2381: IF (NVL(temp_cascaded_table(current_n).deliver_to_location_id, 0) = 0) THEN
2382: temp_cascaded_table(current_n).deliver_to_location_id := x_shipmentdistributionrec.deliver_to_location_id;
2383: END IF;
2384:
2385: /* Bug 2392074 - If the deliver_to_person mentioned in the po_distributions is
2386: invalid or inactive at the time of Receipt we need to clear the deliver to person,
2387: as this is an optional field. */
2388: IF (NVL(temp_cascaded_table(current_n).deliver_to_person_id, 0) = 0) THEN
2389: temp_cascaded_table(current_n).deliver_to_person_id := x_shipmentdistributionrec.deliver_to_person_id;
4044:
4045: IF x_item_revision_record.item_revision IS NULL THEN -- see whether any destination_type = 'INVENTORY'
4046: SELECT COUNT(*)
4047: INTO x_number_of_inv_dest
4048: FROM po_distributions pd
4049: WHERE pd.line_location_id = x_item_revision_record.po_line_location_id
4050: AND pd.destination_type_code = 'INVENTORY';
4051: END IF;
4052: