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_INTERFACE dependencies on STANDARD

Line 93: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

89: AND pl.item_description = v_item_desc))
90: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
91: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
92: AND NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
93: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
94: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
95: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
96: AND rsl.shipment_header_id = v_shipment_header_id
97: AND rsl.po_line_location_id = pll.line_location_id

Line 158: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

154: AND pl.item_description = v_item_desc))
155: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
156: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
157: AND NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
158: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
159: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
160: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
161: AND rsl.shipment_header_id = v_shipment_header_id
162: AND rsl.po_line_location_id = pll.line_location_id

Line 239: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

235: AND pl.item_description = v_item_desc))
236: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
237: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
238: AND NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
239: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
240: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
241: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
242: AND rsl.shipment_header_id = v_shipment_header_id
243: AND rsl.po_line_location_id = pll.line_location_id

Line 309: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

305: AND pl.item_description = v_item_desc))
306: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
307: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
308: AND NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
309: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
310: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
311: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
312: AND rsl.shipment_header_id = v_shipment_header_id
313: AND rsl.po_line_location_id = pll.line_location_id

Line 388: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

384: AND pl.item_description = v_item_desc))
385: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
386: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
387: AND NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
388: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
389: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
390: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
391: AND rsl.shipment_header_id = v_shipment_header_id
392: AND rsl.po_line_location_id = pll.line_location_id

Line 453: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

449: AND pl.item_description = v_item_desc))
450: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
451: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
452: AND NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
453: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
454: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
455: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
456: AND rsl.shipment_header_id = v_shipment_header_id
457: AND rsl.po_line_location_id = pll.line_location_id

Line 534: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

530: AND pl.item_description = v_item_desc))
531: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
532: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
533: AND NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
534: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
535: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
536: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
537: AND rsl.shipment_header_id = v_shipment_header_id
538: AND rsl.po_line_location_id = pll.line_location_id

Line 604: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

600: AND pl.item_description = v_item_desc))
601: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
602: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
603: AND NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
604: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
605: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
606: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
607: AND rsl.shipment_header_id = v_shipment_header_id
608: AND rsl.po_line_location_id = pll.line_location_id

Line 695: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

691: OR (v_revision IS NULL))
692: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
693: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
694: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
695: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
696: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
697: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
698: AND Nvl(pll.receiving_routing_id,1) = Decode(l_allow_routing_override,
699: 'Y',

Line 767: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

763: OR (v_revision IS NULL))
764: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
765: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
766: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
767: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
768: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
769: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
770: AND Nvl(pll.receiving_routing_id,1) = Decode(l_allow_routing_override,
771: 'Y',

Line 842: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

838: OR (v_revision IS NULL))
839: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
840: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
841: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
842: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
843: and pll.line_location_id = pod.line_location_id
844: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
845: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
846: AND Nvl(pll.receiving_routing_id,1) = Decode(l_allow_routing_override,

Line 894: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

890: OR (v_revision IS NULL))
891: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
892: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
893: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
894: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
895: and pll.line_location_id = pod.line_location_id
896: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
897: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
898: AND Nvl(pll.receiving_routing_id,1) = Decode(l_allow_routing_override,

Line 968: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

964: -- and pl.item_id = v_item_id
965: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
966: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
967: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED')
968: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
969: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
970: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
971: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
972: -- for all the transactions in rt for which we can putaway, the

Line 1068: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

1064: -- and NVL(pl.item_id,0) = nvl(v_item_id,nvl(pl.item_id,0))
1065: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
1066: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
1067: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED')
1068: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1069: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
1070: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
1071: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
1072: -- for all the transactions in rt for which we can putaway, the

Line 1174: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

1170: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
1171: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
1172: --and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
1173: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED')
1174: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1175: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
1176: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
1177: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
1178: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)

Line 1261: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

1257: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
1258: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
1259: --and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
1260: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED')
1261: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1262: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
1263: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
1264: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
1265: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)

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

2785:
2786: ELSIF (x_cascaded_table(n).transaction_type = 'STD_DELIVER') THEN
2787: IF l_print_debug = 1 THEN
2788: IF (l_debug = 1) THEN
2789: print_debug('standard delivery',4);
2790: print_debug('po_distribution_id:'||x_ShipmentDistributionRec.po_distribution_id,4);
2791: print_debug('rcv_transaction_id:'||x_ShipmentDistributionRec.rcv_transaction_id,4);
2792: END IF;
2793: END IF;

Line 2795: 'STANDARD DELIVER',

2791: print_debug('rcv_transaction_id:'||x_ShipmentDistributionRec.rcv_transaction_id,4);
2792: END IF;
2793: END IF;
2794: rcv_quantities_s.get_available_quantity(
2795: 'STANDARD DELIVER',
2796: x_ShipmentDistributionRec.po_distribution_id,
2797: 'VENDOR',
2798: null,
2799: x_ShipmentDistributionRec.rcv_transaction_id,