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.INV_RCV_TXN_MATCH dependencies on STANDARD

Line 98: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

94: AND rsl.item_description = v_item_desc))
95: AND poll.approved_flag = 'Y'
96: AND Nvl(poll.cancel_flag, 'N') = 'N'
97: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
98: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
99: AND poll.line_location_id = rsl.po_line_location_id
100: AND rsh.asn_type IN ('ASN', 'ASBN')
101: -- bug 2752051
102: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 147: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

143: AND rsl.item_description = v_item_desc))
144: AND poll.approved_flag = 'Y'
145: AND Nvl(poll.cancel_flag, 'N') = 'N'
146: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
147: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
148: AND poll.line_location_id = rsl.po_line_location_id
149: AND rsh.asn_type IN ('ASN', 'ASBN')
150: -- bug 2752051
151: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 197: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

193: AND rsl.item_description = v_item_desc))
194: AND poll.approved_flag = 'Y'
195: AND Nvl(poll.cancel_flag, 'N') = 'N'
196: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
197: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
198: AND poll.line_location_id = rsl.po_line_location_id
199: AND rsh.asn_type IN ('ASN', 'ASBN')
200: -- bug 2752051
201: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 234: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

230: AND rsl.item_description = v_item_desc))
231: AND poll.approved_flag = 'Y'
232: AND Nvl(poll.cancel_flag, 'N') = 'N'
233: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
234: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
235: AND poll.line_location_id = rsl.po_line_location_id
236: AND rsh.asn_type IN ('ASN', 'ASBN')
237: -- bug 2752051
238: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 292: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

288: AND rsl.item_description = v_item_desc))
289: AND poll.approved_flag = 'Y'
290: AND Nvl(poll.cancel_flag, 'N') = 'N'
291: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
292: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
293: AND poll.line_location_id = rsl.po_line_location_id
294: AND rsh.asn_type IN ('ASN', 'ASBN')
295: -- bug 2752051
296: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 346: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

342: AND rsl.item_description = v_item_desc))
343: AND poll.approved_flag = 'Y'
344: AND Nvl(poll.cancel_flag, 'N') = 'N'
345: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
346: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
347: AND poll.line_location_id = rsl.po_line_location_id
348: AND rsh.asn_type IN ('ASN', 'ASBN')
349: -- bug 2752051
350: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 401: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

397: AND rsl.item_description = v_item_desc))
398: AND poll.approved_flag = 'Y'
399: AND Nvl(poll.cancel_flag, 'N') = 'N'
400: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
401: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
402: AND poll.line_location_id = rsl.po_line_location_id
403: AND rsh.asn_type IN ('ASN', 'ASBN')
404: -- bug 2752051
405: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 443: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

439: AND rsl.item_description = v_item_desc))
440: AND poll.approved_flag = 'Y'
441: AND Nvl(poll.cancel_flag, 'N') = 'N'
442: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
443: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
444: AND poll.line_location_id = rsl.po_line_location_id
445: AND rsh.asn_type IN ('ASN', 'ASBN')
446: -- bug 2752051
447: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 507: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

503: AND rsl.item_description = v_item_desc))
504: AND poll.approved_flag = 'Y'
505: AND Nvl(poll.cancel_flag, 'N') = 'N'
506: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
507: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
508: AND poll.line_location_id = rsl.po_line_location_id
509: AND rsh.asn_type IN ('LCM')
510: -- bug 2752051
511: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 549: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

545: AND rsl.item_description = v_item_desc))
546: AND poll.approved_flag = 'Y'
547: AND Nvl(poll.cancel_flag, 'N') = 'N'
548: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
549: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
550: AND poll.line_location_id = rsl.po_line_location_id
551: AND rsh.asn_type IN ('LCM')
552: -- bug 2752051
553: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 599: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

595: AND rsl.item_description = v_item_desc))
596: AND poll.approved_flag = 'Y'
597: AND Nvl(poll.cancel_flag, 'N') = 'N'
598: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
599: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
600: AND poll.line_location_id = rsl.po_line_location_id
601: AND rsh.asn_type IN ('LCM')
602: -- bug 2752051
603: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 629: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

625: AND rsl.item_description = v_item_desc))
626: AND poll.approved_flag = 'Y'
627: AND Nvl(poll.cancel_flag, 'N') = 'N'
628: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
629: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
630: AND poll.line_location_id = rsl.po_line_location_id
631: AND rsh.asn_type IN ('LCM')
632: -- bug 2752051
633: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 687: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

683: AND rsl.item_description = v_item_desc))
684: AND poll.approved_flag = 'Y'
685: AND Nvl(poll.cancel_flag, 'N') = 'N'
686: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
687: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
688: AND poll.line_location_id = rsl.po_line_location_id
689: AND rsh.asn_type IN ('LCM')
690: -- bug 2752051
691: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 734: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

730: AND rsl.item_description = v_item_desc))
731: AND poll.approved_flag = 'Y'
732: AND Nvl(poll.cancel_flag, 'N') = 'N'
733: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
734: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
735: AND poll.line_location_id = rsl.po_line_location_id
736: AND rsh.asn_type IN ('LCM')
737: -- bug 2752051
738: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 789: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

785: AND rsl.item_description = v_item_desc))
786: AND poll.approved_flag = 'Y'
787: AND Nvl(poll.cancel_flag, 'N') = 'N'
788: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
789: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
790: AND poll.line_location_id = rsl.po_line_location_id
791: AND rsh.asn_type IN ('LCM')
792: -- bug 2752051
793: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 824: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')

820: AND rsl.item_description = v_item_desc))
821: AND poll.approved_flag = 'Y'
822: AND Nvl(poll.cancel_flag, 'N') = 'N'
823: AND Nvl(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
824: AND poll.shipment_type IN ('STANDARD', 'BLANKET', 'SCHEDULED')
825: AND poll.line_location_id = rsl.po_line_location_id
826: AND rsh.asn_type IN ('LCM')
827: -- bug 2752051
828: AND rsl.shipment_line_status_code IN ('EXPECTED','PARTIALLY RECEIVED') --<> 'CANCELLED'

Line 1420: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

1416: AND rsup.PO_LINE_LOCATION_ID = poll.LINE_LOCATION_ID
1417: and NVL(poll.APPROVED_FLAG,'N') = 'Y'
1418: and NVL(poll.CANCEL_FLAG, 'N') = 'N'
1419: and NVL(poll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
1420: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1421: AND rt.transaction_date < Nvl(v_txn_date, (rt.transaction_date +1))
1422: AND (RT.ROUTING_HEADER_ID IS NULL OR
1423: RT.ROUTING_HEADER_ID <> 2 OR
1424: (rt.routing_header_id = 2

Line 1497: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

1493: AND rsup.PO_LINE_LOCATION_ID = poll.LINE_LOCATION_ID
1494: and NVL(poll.APPROVED_FLAG,'N') = 'Y'
1495: and NVL(poll.CANCEL_FLAG, 'N') = 'N'
1496: and NVL(poll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
1497: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1498: AND rt.transaction_date < Nvl(v_txn_date, (rt.transaction_date +1))
1499: AND (RT.ROUTING_HEADER_ID IS NULL OR
1500: RT.ROUTING_HEADER_ID <> 2 OR
1501: (rt.routing_header_id = 2

Line 1590: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

1586: AND rsup.PO_LINE_LOCATION_ID = poll.LINE_LOCATION_ID
1587: and NVL(poll.APPROVED_FLAG,'N') = 'Y'
1588: and NVL(poll.CANCEL_FLAG, 'N') = 'N'
1589: and NVL(poll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
1590: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1591: AND rt.transaction_date < Nvl(v_txn_date, (rt.transaction_date +1))
1592: AND (RT.ROUTING_HEADER_ID IS NULL OR
1593: RT.ROUTING_HEADER_ID <> 2 OR
1594: (rt.routing_header_id = 2

Line 1667: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

1663: AND rsup.PO_LINE_LOCATION_ID = poll.LINE_LOCATION_ID
1664: and NVL(poll.APPROVED_FLAG,'N') = 'Y'
1665: and NVL(poll.CANCEL_FLAG, 'N') = 'N'
1666: and NVL(poll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
1667: and poll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1668: AND rt.transaction_date < Nvl(v_txn_date, (rt.transaction_date +1))
1669: AND (RT.ROUTING_HEADER_ID IS NULL OR
1670: RT.ROUTING_HEADER_ID <> 2 OR
1671: (rt.routing_header_id = 2

Line 1881: print_debug('Opening for ASN standard receipt', 4);

1877: print_debug('item_desc'||temp_cascaded_table(current_n).item_desc, 4);
1878: END IF;
1879: IF (x_cascaded_table(n).transaction_type = 'RECEIVE') THEN
1880: IF (l_debug = 1) THEN
1881: print_debug('Opening for ASN standard receipt', 4);
1882: END IF;
1883: OPEN asn_receipt_lines
1884: (temp_cascaded_table(current_n).shipment_header_id,
1885: temp_cascaded_table(current_n).shipment_line_id,

Line 1944: print_debug('Opening for LCM standard receipt', 4);

1940: print_debug('item_desc'||temp_cascaded_table(current_n).item_desc, 4);
1941: END IF;
1942: IF (x_cascaded_table(n).transaction_type = 'RECEIVE') THEN
1943: IF (l_debug = 1) THEN
1944: print_debug('Opening for LCM standard receipt', 4);
1945: END IF;
1946: OPEN lcm_receipt_lines
1947: (temp_cascaded_table(current_n).shipment_header_id,
1948: temp_cascaded_table(current_n).shipment_line_id,

Line 2953: print_debug('standard delivery rcv_transaction_id:'||x_MatchedRec.rcv_transaction_id,4);

2949:
2950: ELSIF (x_cascaded_table(n).transaction_type = 'STD_DELIVER') THEN
2951:
2952: IF (l_debug = 1) THEN
2953: print_debug('standard delivery rcv_transaction_id:'||x_MatchedRec.rcv_transaction_id,4);
2954: print_debug('receipt_source_code:'||x_MatchedRec.receipt_source_code,4);
2955: END IF;
2956:
2957: -- For Bug 7440217 for LCM changes

Line 2960: print_debug('standard delivery',4);

2956:
2957: -- For Bug 7440217 for LCM changes
2958: IF p_match_type IN ('ASN', 'LCM') THEN
2959: -- End for Bug 7440217
2960: print_debug('standard delivery',4);
2961: print_debug('po_distribution_id:'||x_MatchedRec.po_distribution_id,4);
2962: print_debug('rcv_transaction_id:'||x_MatchedRec.rcv_transaction_id,4);
2963: rcv_quantities_s.get_available_quantity(
2964: 'STANDARD DELIVER',

Line 2964: 'STANDARD DELIVER',

2960: print_debug('standard delivery',4);
2961: print_debug('po_distribution_id:'||x_MatchedRec.po_distribution_id,4);
2962: print_debug('rcv_transaction_id:'||x_MatchedRec.rcv_transaction_id,4);
2963: rcv_quantities_s.get_available_quantity(
2964: 'STANDARD DELIVER',
2965: x_MatchedRec.po_distribution_id,
2966: 'VENDOR',
2967: null,
2968: x_MatchedRec.rcv_transaction_id,