[Home] [Help]
2080:
2081: -- Cursor to lock the WDD demand record
2082: CURSOR lock_wdd_record(p_delivery_detail_id NUMBER) IS
2083: SELECT delivery_detail_id
2084: FROM wsh_delivery_details
2085: WHERE delivery_detail_id = p_delivery_detail_id
2086: FOR UPDATE NOWAIT;
2087:
2088: -- Variables used for the current WDD demand record
6416: wdd.requested_quantity_uom2 AS secondary_uom_code,
6417: wdd.project_id AS project_id,
6418: wdd.task_id AS task_id,
6419: NULL AS wip_supply_type
6420: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6421: WHERE wdd.organization_id = l_organization_id
6422: AND wdd.inventory_item_id = l_inventory_item_id
6423: AND wdd.released_status = 'R'
6424: AND wdd.source_code = 'OE'
6451: wdd.requested_quantity_uom2 AS secondary_uom_code,
6452: wdd.project_id AS project_id,
6453: wdd.task_id AS task_id,
6454: NULL AS wip_supply_type
6455: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6456: WHERE wdd.organization_id = l_organization_id
6457: AND wdd.inventory_item_id = l_inventory_item_id
6458: AND wdd.released_status = 'B'
6459: AND wdd.source_code = 'OE'
6486: wdd.requested_quantity_uom2 AS secondary_uom_code,
6487: wdd.project_id AS project_id,
6488: wdd.task_id AS task_id,
6489: NULL AS wip_supply_type
6490: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6491: WHERE wdd.organization_id = l_organization_id
6492: AND wdd.inventory_item_id = l_inventory_item_id
6493: AND wdd.released_status = 'R'
6494: AND wdd.source_code = 'OE'
6521: wdd.requested_quantity_uom2 AS secondary_uom_code,
6522: wdd.project_id AS project_id,
6523: wdd.task_id AS task_id,
6524: NULL AS wip_supply_type
6525: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6526: WHERE wdd.organization_id = l_organization_id
6527: AND wdd.inventory_item_id = l_inventory_item_id
6528: AND wdd.released_status = 'B'
6529: AND wdd.source_code = 'OE'
6758: CURSOR reserved_wdd_lines(p_project_id NUMBER, p_task_id NUMBER) IS
6759: SELECT wdd.delivery_detail_id, wdd.requested_quantity, wdd.requested_quantity_uom,
6760: wdd.requested_quantity2, wdd.requested_quantity_uom2,
6761: wdd.released_status, wdd.project_id, wdd.task_id
6762: FROM wsh_delivery_details wdd, oe_order_lines_all ool
6763: WHERE wdd.organization_id = l_organization_id
6764: AND wdd.inventory_item_id = l_inventory_item_id
6765: AND wdd.released_status IN ('R', 'B')
6766: AND wdd.source_code = 'OE'
6970:
6971: -- Cursor to lock the WDD demand record
6972: CURSOR lock_wdd_record(p_delivery_detail_id NUMBER) IS
6973: SELECT delivery_detail_id
6974: FROM wsh_delivery_details
6975: WHERE delivery_detail_id = p_delivery_detail_id
6976: FOR UPDATE NOWAIT;
6977:
6978: -- Cursor to lock the WIP demand record.
7017: p_repetitive_schedule_id NUMBER,
7018: p_demand_source_header_id NUMBER,
7019: p_demand_source_line_id NUMBER) IS
7020: SELECT NVL(SUM(mtrl.primary_quantity), 0)
7021: FROM mtl_txn_request_lines mtrl, wsh_delivery_details wdd,
7022: wms_license_plate_numbers wlpn
7023: WHERE mtrl.organization_id = l_organization_id
7024: AND mtrl.inventory_item_id = l_inventory_item_id
7025: -- Modified the line below to use an IN instead of <> so the
9915: NVL(wc_ool.carrier_id, wcs_ool.carrier_id)))) AS carrier_id,
9916: NVL(wts.planned_departure_date,
9917: NVL(wdd.date_scheduled,
9918: NVL(ool.schedule_ship_date, ool.promise_date))) AS expected_ship_date
9919: FROM wsh_delivery_details wdd, oe_order_lines_all ool,
9920: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9921: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9922: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool, wsh_carriers wc_ool
9923: WHERE wdd.delivery_detail_id = p_source_line_detail_id
9957: NVL(NVL(wdd.carrier_id, wcs_wdd.carrier_id),
9958: wc_poll.carrier_id))) AS carrier_id,
9959: NVL(wts.planned_arrival_date,
9960: NVL(poll.promised_date, poll.need_by_date)) AS expected_receipt_date
9961: FROM po_line_locations_all poll, wsh_delivery_details wdd,
9962: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
9963: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
9964: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll
9965: WHERE poll.po_header_id = p_source_header_id
10005: wc_poll.carrier_id)))) AS carrier_id,
10006: NVL(wts.planned_arrival_date,
10007: NVL(NVL(rsh.expected_receipt_date, rsh.shipped_date),
10008: NVL(poll.promised_date, poll.need_by_date))) AS expected_receipt_date
10009: FROM po_line_locations_all poll, wsh_delivery_details wdd,
10010: rcv_shipment_headers rsh, rcv_shipment_lines rsl,
10011: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
10012: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
10013: wsh_carrier_services wcs_wdd, wsh_carriers wc_poll, wsh_carriers wc_rsh
10071: NVL(wts.planned_arrival_date,
10072: NVL(NVL(rsh.expected_receipt_date, rsh.shipped_date),
10073: prl.need_by_date)) AS expected_receipt_date
10074: FROM po_requisition_lines_all prl, rcv_shipment_lines rsl, rcv_shipment_headers rsh,
10075: oe_order_lines_all ool, wsh_delivery_details wdd,
10076: wsh_delivery_assignments_v wda, wsh_new_deliveries wnd, wsh_delivery_legs wdl,
10077: wsh_trip_stops wts, wsh_trips wt, wsh_carrier_services wcs_wnd,
10078: wsh_carrier_services wcs_wdd, wsh_carrier_services wcs_ool,
10079: wsh_carriers wc_ool, wsh_carriers wc_rsh, wsh_carrier_services wcs_prl
10688: NVL(ool.schedule_ship_date, ool.promise_date)))) AS min_expected_ship_date,
10689: MAX(NVL(wts.planned_departure_date,
10690: NVL(wdd.date_scheduled,
10691: NVL(ool.schedule_ship_date, ool.promise_date)))) AS max_expected_ship_date
10692: FROM wsh_new_deliveries wnd, wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
10693: wsh_delivery_legs wdl, wsh_trip_stops wts, wsh_trips wt, oe_order_lines_all ool,
10694: wsh_carrier_services wcs_wnd, wsh_carrier_services wcs_wdd,
10695: wsh_carrier_services wcs_ool, wsh_carriers wc_ool
10696: WHERE wnd.delivery_id = p_delivery_id