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 694: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')

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

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

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

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

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

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

884: OR (v_revision IS NULL))
885: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
886: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
887: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
888: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
889: and pll.line_location_id = pod.line_location_id
890: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
891: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
892: AND Nvl(pll.receiving_routing_id,1) = Decode(l_allow_routing_override,

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

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

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

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

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

1164: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
1165: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
1166: --and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
1167: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED')
1168: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1169: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
1170: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
1171: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
1172: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)

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

1251: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
1252: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
1253: --and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')
1254: and NVL(pll.CLOSED_CODE,'OPEN') NOT IN ('FINALLY CLOSED')
1255: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
1256: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
1257: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
1258: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
1259: AND Nvl(v_lpn_id,-1) IN (select nvl(rt2.transfer_lpn_id,-1)

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

2576:
2577: ELSIF (x_cascaded_table(n).transaction_type = 'STD_DELIVER') THEN
2578: IF l_print_debug = 1 THEN
2579: IF (l_debug = 1) THEN
2580: print_debug('standard delivery',4);
2581: print_debug('po_distribution_id:'||x_ShipmentDistributionRec.po_distribution_id,4);
2582: print_debug('rcv_transaction_id:'||x_ShipmentDistributionRec.rcv_transaction_id,4);
2583: END IF;
2584: END IF;

Line 2586: 'STANDARD DELIVER',

2582: print_debug('rcv_transaction_id:'||x_ShipmentDistributionRec.rcv_transaction_id,4);
2583: END IF;
2584: END IF;
2585: rcv_quantities_s.get_available_quantity(
2586: 'STANDARD DELIVER',
2587: x_ShipmentDistributionRec.po_distribution_id,
2588: 'VENDOR',
2589: null,
2590: x_ShipmentDistributionRec.rcv_transaction_id,