96: AND rsl.item_description = v_item_desc))
97: AND poll.approved_flag = 'Y'
98: AND Nvl(poll.cancel_flag, 'N') = 'N'
99: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
100: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
101: AND poll.line_location_id = rsl.po_line_location_id
102: AND rsh.asn_type IN ('ASN', 'ASBN')
103: -- bug 2752051
104: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
145: AND rsl.item_description = v_item_desc))
146: AND poll.approved_flag = 'Y'
147: AND Nvl(poll.cancel_flag, 'N') = 'N'
148: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
149: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
150: AND poll.line_location_id = rsl.po_line_location_id
151: AND rsh.asn_type IN ('ASN', 'ASBN')
152: -- bug 2752051
153: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
197: AND rsl.item_description = v_item_desc))
198: AND poll.approved_flag = 'Y'
199: AND Nvl(poll.cancel_flag, 'N') = 'N'
200: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
201: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
202: AND poll.line_location_id = rsl.po_line_location_id
203: AND rsh.asn_type IN ('ASN', 'ASBN')
204: -- bug 2752051
205: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
234: AND rsl.item_description = v_item_desc))
235: AND poll.approved_flag = 'Y'
236: AND Nvl(poll.cancel_flag, 'N') = 'N'
237: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
238: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
239: AND poll.line_location_id = rsl.po_line_location_id
240: AND rsh.asn_type IN ('ASN', 'ASBN')
241: -- bug 2752051
242: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
325: AND rsl.item_description = v_item_desc))
326: AND poll.approved_flag = 'Y'
327: AND Nvl(poll.cancel_flag, 'N') = 'N'
328: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
329: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
330: AND poll.line_location_id = rsl.po_line_location_id
331: AND rsh.asn_type IN ('ASN', 'ASBN')
332: -- bug 2752051
333: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
382: AND rsl.item_description = v_item_desc))
383: AND poll.approved_flag = 'Y'
384: AND Nvl(poll.cancel_flag, 'N') = 'N'
385: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
386: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
387: AND poll.line_location_id = rsl.po_line_location_id
388: AND rsh.asn_type IN ('ASN', 'ASBN')
389: -- bug 2752051
390: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
454: AND rsl.item_description = v_item_desc))
455: AND poll.approved_flag = 'Y'
456: AND Nvl(poll.cancel_flag, 'N') = 'N'
457: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
458: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
459: AND poll.line_location_id = rsl.po_line_location_id
460: AND rsh.asn_type IN ('ASN', 'ASBN')
461: -- bug 2752051
462: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
497: AND rsl.item_description = v_item_desc))
498: AND poll.approved_flag = 'Y'
499: AND Nvl(poll.cancel_flag, 'N') = 'N'
500: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
501: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
502: AND poll.line_location_id = rsl.po_line_location_id
503: AND rsh.asn_type IN ('ASN', 'ASBN')
504: -- bug 2752051
505: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
576: AND rsl.item_description = v_item_desc))
577: AND poll.approved_flag = 'Y'
578: AND Nvl(poll.cancel_flag, 'N') = 'N'
579: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
580: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
581: AND poll.line_location_id = rsl.po_line_location_id
582: AND rsh.asn_type IN ('LCM')
583: -- bug 2752051
584: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
618: AND rsl.item_description = v_item_desc))
619: AND poll.approved_flag = 'Y'
620: AND Nvl(poll.cancel_flag, 'N') = 'N'
621: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
622: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
623: AND poll.line_location_id = rsl.po_line_location_id
624: AND rsh.asn_type IN ('LCM')
625: -- bug 2752051
626: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
668: AND rsl.item_description = v_item_desc))
669: AND poll.approved_flag = 'Y'
670: AND Nvl(poll.cancel_flag, 'N') = 'N'
671: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
672: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
673: AND poll.line_location_id = rsl.po_line_location_id
674: AND rsh.asn_type IN ('LCM')
675: -- bug 2752051
676: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
698: AND rsl.item_description = v_item_desc))
699: AND poll.approved_flag = 'Y'
700: AND Nvl(poll.cancel_flag, 'N') = 'N'
701: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
702: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
703: AND poll.line_location_id = rsl.po_line_location_id
704: AND rsh.asn_type IN ('LCM')
705: -- bug 2752051
706: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
756: AND rsl.item_description = v_item_desc))
757: AND poll.approved_flag = 'Y'
758: AND Nvl(poll.cancel_flag, 'N') = 'N'
759: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
760: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
761: AND poll.line_location_id = rsl.po_line_location_id
762: AND rsh.asn_type IN ('LCM')
763: -- bug 2752051
764: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
803: AND rsl.item_description = v_item_desc))
804: AND poll.approved_flag = 'Y'
805: AND Nvl(poll.cancel_flag, 'N') = 'N'
806: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
807: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
808: AND poll.line_location_id = rsl.po_line_location_id
809: AND rsh.asn_type IN ('LCM')
810: -- bug 2752051
811: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
858: AND rsl.item_description = v_item_desc))
859: AND poll.approved_flag = 'Y'
860: AND Nvl(poll.cancel_flag, 'N') = 'N'
861: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
862: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
863: AND poll.line_location_id = rsl.po_line_location_id
864: AND rsh.asn_type IN ('LCM')
865: -- bug 2752051
866: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
893: AND rsl.item_description = v_item_desc))
894: AND poll.approved_flag = 'Y'
895: AND Nvl(poll.cancel_flag, 'N') = 'N'
896: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
897: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
898: AND poll.line_location_id = rsl.po_line_location_id
899: AND rsh.asn_type IN ('LCM')
900: -- bug 2752051
901: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'
1608: AND rsup.PO_LINE_LOCATION_ID = poll.LINE_LOCATION_ID
1609: and NVL(poll.APPROVED_FLAG,'N') = 'Y'
1610: and NVL(poll.CANCEL_FLAG, 'N') = 'N'
1611: and NVL(poll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
1612: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1613: AND rt.transaction_date < Nvl(v_txn_date, (rt.transaction_date +1))
1614: AND (RT.ROUTING_HEADER_ID IS NULL OR
1615: RT.ROUTING_HEADER_ID <> 2 OR
1616: (rt.routing_header_id = 2
1689: AND rsup.PO_LINE_LOCATION_ID = poll.LINE_LOCATION_ID
1690: and NVL(poll.APPROVED_FLAG,'N') = 'Y'
1691: and NVL(poll.CANCEL_FLAG, 'N') = 'N'
1692: and NVL(poll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
1693: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1694: AND rt.transaction_date < Nvl(v_txn_date, (rt.transaction_date +1))
1695: AND (RT.ROUTING_HEADER_ID IS NULL OR
1696: RT.ROUTING_HEADER_ID <> 2 OR
1697: (rt.routing_header_id = 2
1783: AND rsup.PO_LINE_LOCATION_ID = poll.LINE_LOCATION_ID
1784: and NVL(poll.APPROVED_FLAG,'N') = 'Y'
1785: and NVL(poll.CANCEL_FLAG, 'N') = 'N'
1786: and NVL(poll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
1787: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1788: AND rt.transaction_date < Nvl(v_txn_date, (rt.transaction_date +1))
1789: AND (RT.ROUTING_HEADER_ID IS NULL OR
1790: RT.ROUTING_HEADER_ID <> 2 OR
1791: (rt.routing_header_id = 2
1860: AND rsup.PO_LINE_LOCATION_ID = poll.LINE_LOCATION_ID
1861: and NVL(poll.APPROVED_FLAG,'N') = 'Y'
1862: and NVL(poll.CANCEL_FLAG, 'N') = 'N'
1863: and NVL(poll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
1864: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1865: AND rt.transaction_date < Nvl(v_txn_date, (rt.transaction_date +1))
1866: AND (RT.ROUTING_HEADER_ID IS NULL OR
1867: RT.ROUTING_HEADER_ID <> 2 OR
1868: (rt.routing_header_id = 2
2079: print_debug('unit_of_measure'||temp_cascaded_table(current_n).unit_of_measure, 4); --14776842
2080: END IF;
2081: IF (x_cascaded_table(n).transaction_type = 'RECEIVE') THEN
2082: IF (l_debug = 1) THEN
2083: print_debug('Opening for ASN standard receipt', 4);
2084: END IF;
2085: OPEN asn_receipt_lines
2086: (temp_cascaded_table(current_n).shipment_header_id,
2087: temp_cascaded_table(current_n).shipment_line_id,
2149: print_debug('item_desc'||temp_cascaded_table(current_n).item_desc, 4);
2150: END IF;
2151: IF (x_cascaded_table(n).transaction_type = 'RECEIVE') THEN
2152: IF (l_debug = 1) THEN
2153: print_debug('Opening for LCM standard receipt', 4);
2154: END IF;
2155: OPEN lcm_receipt_lines
2156: (temp_cascaded_table(current_n).shipment_header_id,
2157: temp_cascaded_table(current_n).shipment_line_id,
3257:
3258: ELSIF (x_cascaded_table(n).transaction_type = 'STD_DELIVER') THEN
3259:
3260: IF (l_debug = 1) THEN
3261: print_debug('standard delivery rcv_transaction_id:'||x_MatchedRec.rcv_transaction_id,4);
3262: print_debug('receipt_source_code:'||x_MatchedRec.receipt_source_code,4);
3263: END IF;
3264:
3265: -- For Bug 7440217 for LCM changes
3264:
3265: -- For Bug 7440217 for LCM changes
3266: IF p_match_type IN ('ASN', 'LCM') THEN
3267: -- End for Bug 7440217
3268: print_debug('standard delivery',4);
3269: print_debug('po_distribution_id:'||x_MatchedRec.po_distribution_id,4);
3270: print_debug('rcv_transaction_id:'||x_MatchedRec.rcv_transaction_id,4);
3271: rcv_quantities_s.get_available_quantity(
3272: 'STANDARD DELIVER',
3268: print_debug('standard delivery',4);
3269: print_debug('po_distribution_id:'||x_MatchedRec.po_distribution_id,4);
3270: print_debug('rcv_transaction_id:'||x_MatchedRec.rcv_transaction_id,4);
3271: rcv_quantities_s.get_available_quantity(
3272: 'STANDARD DELIVER',
3273: x_MatchedRec.po_distribution_id,
3274: 'VENDOR',
3275: null,
3276: x_MatchedRec.rcv_transaction_id,