[Home] [Help]
2055:
2056: -- Cursor to lock the WDD demand record
2057: CURSOR lock_wdd_record(p_delivery_detail_id NUMBER) IS
2058: SELECT delivery_detail_id
2059: FROM wsh_delivery_details
2060: WHERE delivery_detail_id = p_delivery_detail_id
2061: FOR UPDATE NOWAIT;
2062:
2063: -- Variables used for the current WDD demand record
6245: wdd.requested_quantity_uom2 AS secondary_uom_code,
6246: wdd.project_id AS project_id,
6247: wdd.task_id AS task_id,
6248: NULL AS wip_supply_type
6249: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6250: WHERE wdd.organization_id = l_organization_id
6251: AND wdd.inventory_item_id = l_inventory_item_id
6252: AND wdd.released_status = 'R'
6253: AND wdd.source_code = 'OE'
6279: wdd.requested_quantity_uom2 AS secondary_uom_code,
6280: wdd.project_id AS project_id,
6281: wdd.task_id AS task_id,
6282: NULL AS wip_supply_type
6283: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6284: WHERE wdd.organization_id = l_organization_id
6285: AND wdd.inventory_item_id = l_inventory_item_id
6286: AND wdd.released_status = 'B'
6287: AND wdd.source_code = 'OE'
6313: wdd.requested_quantity_uom2 AS secondary_uom_code,
6314: wdd.project_id AS project_id,
6315: wdd.task_id AS task_id,
6316: NULL AS wip_supply_type
6317: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6318: WHERE wdd.organization_id = l_organization_id
6319: AND wdd.inventory_item_id = l_inventory_item_id
6320: AND wdd.released_status = 'R'
6321: AND wdd.source_code = 'OE'
6347: wdd.requested_quantity_uom2 AS secondary_uom_code,
6348: wdd.project_id AS project_id,
6349: wdd.task_id AS task_id,
6350: NULL AS wip_supply_type
6351: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6352: WHERE wdd.organization_id = l_organization_id
6353: AND wdd.inventory_item_id = l_inventory_item_id
6354: AND wdd.released_status = 'B'
6355: AND wdd.source_code = 'OE'
6583: CURSOR reserved_wdd_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6584: SELECT wdd.delivery_detail_id, wdd.requested_quantity, wdd.requested_quantity_uom,
6585: wdd.requested_quantity2, wdd.requested_quantity_uom2,
6586: wdd.released_status, wdd.project_id, wdd.task_id
6587: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6588: WHERE wdd.organization_id = l_organization_id
6589: AND wdd.inventory_item_id = l_inventory_item_id
6590: AND wdd.released_status IN ('R', 'B')
6591: AND wdd.source_code = 'OE'
6795:
6796: -- Cursor to lock the WDD demand record
6797: CURSOR lock_wdd_record(p_delivery_detail_id NUMBER) IS
6798: SELECT delivery_detail_id
6799: FROM wsh_delivery_details
6800: WHERE delivery_detail_id = p_delivery_detail_id
6801: FOR UPDATE NOWAIT;
6802:
6803: -- Cursor to lock the WIP demand record.
6842: p_repetitive_schedule_id NUMBER,
6843: p_demand_source_header_id NUMBER,
6844: p_demand_source_line_id NUMBER) IS
6845: SELECT NVL(SUM(mtrl.primary_quantity), 0)
6846: FROM mtl_txn_request_lines mtrl, wsh_delivery_details wdd,
6847: wms_license_plate_numbers wlpn
6848: WHERE mtrl.organization_id = l_organization_id
6849: AND mtrl.inventory_item_id = l_inventory_item_id
6850: -- Modified the line below to use an IN instead of <> so the
9720: NVL(wc_ool.carrier_id, wcs_ool.carrier_id)))) AS carrier_id,
9721: NVL(wts.planned_departure_date,
9722: NVL(wdd.date_scheduled,
9723: NVL(ool.schedule_ship_date, ool.promise_date))) AS expected_ship_date
9724: FROM wsh_delivery_details wdd, oe_order_lines_all ool,
9725: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9726: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9727: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool, wsh_carriers wc_ool
9728: WHERE wdd.delivery_detail_id = p_source_line_detail_id
9762: NVL(NVL(wdd.carrier_id, wcs_wdd.carrier_id),
9763: wc_poll.carrier_id))) AS carrier_id,
9764: NVL(wts.planned_arrival_date,
9765: NVL(poll.promised_date, poll.need_by_date)) AS expected_receipt_date
9766: FROM po_line_locations_all poll, wsh_delivery_details wdd,
9767: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9768: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9769: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll
9770: WHERE poll.po_header_id = p_source_header_id
9810: wc_poll.carrier_id)))) AS carrier_id,
9811: NVL(wts.planned_arrival_date,
9812: NVL(NVL(rsh.expected_receipt_date, rsh.shipped_date),
9813: NVL(poll.promised_date, poll.need_by_date))) AS expected_receipt_date
9814: FROM po_line_locations_all poll, wsh_delivery_details wdd,
9815: rcv_shipment_headers rsh, rcv_shipment_lines rsl,
9816: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9817: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9818: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll, wsh_carriers wc_rsh
9876: NVL(wts.planned_arrival_date,
9877: NVL(NVL(rsh.expected_receipt_date, rsh.shipped_date),
9878: prl.need_by_date)) AS expected_receipt_date
9879: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, rcv_shipment_headers rsh,
9880: oe_order_lines_all ool, wsh_delivery_details wdd,
9881: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9882: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9883: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool,
9884: wsh_carriers wc_ool, wsh_carriers wc_rsh, wsh_carrier_services wcs_prl
10493: NVL(ool.schedule_ship_date, ool.promise_date)))) AS min_expected_ship_date,
10494: MAX(NVL(wts.planned_departure_date,
10495: NVL(wdd.date_scheduled,
10496: NVL(ool.schedule_ship_date, ool.promise_date)))) AS max_expected_ship_date
10497: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
10498: wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt, oe_order_lines_all ool,
10499: wsh_carrier_services wcs_wnd, wsh_carrier_services wcs_wdd,
10500: wsh_carrier_services wcs_ool, wsh_carriers wc_ool
10501: WHERE wnd.delivery_id = p_delivery_id