[Home] [Help]
66: AND pl.item_description = v_item_desc))
67: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
68: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
69: AND NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
70: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
71: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
72: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
73: AND rsl.shipment_header_id = v_shipment_header_id
74: AND rsl.po_line_location_id = pll.line_location_id
120: AND pl.item_description = v_item_desc))
121: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
122: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
123: AND NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
124: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
125: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
126: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
127: AND rsl.shipment_header_id = v_shipment_header_id
128: AND rsl.po_line_location_id = pll.line_location_id
189: AND pl.item_description = v_item_desc))
190: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
191: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
192: AND NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
193: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
194: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
195: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
196: AND rsl.shipment_header_id = v_shipment_header_id
197: AND rsl.po_line_location_id = pll.line_location_id
247: AND pl.item_description = v_item_desc))
248: AND NVL(pll.APPROVED_FLAG,'N') = 'Y'
249: AND NVL(pll.CANCEL_FLAG, 'N') = 'N'
250: AND NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
251: AND pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
252: AND pll.ship_to_organization_id = Nvl(v_ship_to_org_id,pll.ship_to_organization_id)
253: AND pll.ship_to_location_id = Nvl(v_ship_to_location_id,pll.ship_to_location_id)
254: AND rsl.shipment_header_id = v_shipment_header_id
255: AND rsl.po_line_location_id = pll.line_location_id
312: OR (v_revision IS NULL))
313: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
314: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
315: and NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
316: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
317: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
318: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
319: AND pll.line_location_id in
320: ( select pod.line_location_id
361: OR (v_revision IS NULL))
362: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
363: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
364: and NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
365: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
366: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
367: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
368: AND pll.line_location_id in
369: ( select pod.line_location_id
425: OR (v_revision IS NULL))
426: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
427: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
428: and NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
429: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
430: and pll.line_location_id = pod.line_location_id
431: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
432: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
433: and (v_project_id is null or
470: OR (v_revision IS NULL))
471: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
472: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
473: and NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
474: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
475: and pll.line_location_id = pod.line_location_id
476: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
477: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
478: and (v_project_id is null or
528: -- and pl.item_id = v_item_id
529: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
530: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
531: and NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
532: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
533: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
534: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
535: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
536: -- for all the transactions in rt for which we can putaway, the
605: -- and NVL(pl.item_id,0) = nvl(v_item_id,nvl(pl.item_id,0))
606: and NVL(pll.APPROVED_FLAG,'N') = 'Y'
607: and NVL(pll.CANCEL_FLAG, 'N') = 'N'
608: and NVL(pll.CLOSED_CODE,'OPEN') <> 'FINALLY CLOSED'
609: and pll.SHIPMENT_TYPE IN ('STANDARD','BLANKET','SCHEDULED')
610: and pll.ship_to_organization_id = nvl(v_ship_to_org_id,pll.ship_to_organization_id)
611: and pll.ship_to_location_id = nvl(v_ship_to_location_id,pll.ship_to_location_id)
612: AND RT.TRANSACTION_TYPE <> 'UNORDERED'
613: -- for all the transactions in rt for which we can putaway, the
1240: END IF;
1241:
1242: ELSIF (x_cascaded_table(n).transaction_type = 'STD_DELIVER') THEN
1243: rcv_quantities_s.get_available_quantity(
1244: 'STANDARD DELIVER',
1245: x_ShipmentDistributionRec.po_distribution_id,
1246: 'VENDOR',
1247: null,
1248: x_ShipmentDistributionRec.rcv_transaction_id,