APPS.WMS_XDOCK_PEGGING_PUB dependencies on PO_LINE_LOCATIONS_ALL

Line 1747: FROM po_headers_all poh, po_lines_all pol, po_line_locations_all poll,

1743: NULL AS secondary_uom_code,
1744: MIN(pod.project_id) AS project_id,
1745: MIN(pod.task_id) AS task_id,
1746: NULL AS lpn_id
1747: FROM po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
1748: po_distributions_all pod, po_line_types plt, mtl_units_of_measure muom
1749: WHERE poh.type_lookup_code IN ('STANDARD','PLANNED','BLANKET','CONTRACT')
1750: AND NVL(poh.cancel_flag, 'N') IN ('N', 'I')
1751: AND NVL(poh.closed_code, 'OPEN') NOT IN ('FINALLY CLOSED','CLOSED FOR RECEIVING','CLOSED')

Line 1804: po_line_locations_all poll, po_distributions_all pod, mtl_units_of_measure muom

1800: MIN(pod.project_id) AS project_id,
1801: MIN(pod.task_id) AS task_id,
1802: NULL AS lpn_id
1803: FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, po_lines_all pol, po_line_types plt,
1804: po_line_locations_all poll, po_distributions_all pod, mtl_units_of_measure muom
1805: WHERE rsh.shipment_num IS NOT NULL
1806: AND rsh.receipt_source_code = 'VENDOR'
1807: AND rsh.asn_type in ('ASN','ASBN')
1808: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 2187: FROM po_line_locations_all poll, mtl_units_of_measure muom,

2183:
2184: -- Cursor to lock the PO supply line record.
2185: CURSOR lock_po_record(p_uom_code VARCHAR2, p_project_id NUMBER, p_task_id NUMBER) IS
2186: SELECT muom.uom_code, pod.project_id, pod.task_id
2187: FROM po_line_locations_all poll, mtl_units_of_measure muom,
2188: (SELECT po_header_id, po_line_id, line_location_id,
2189: MIN(project_id) AS project_id, MIN(task_id) AS task_id
2190: FROM po_distributions_all
2191: WHERE po_header_id = l_supply_header_id

Line 2212: FROM rcv_shipment_lines rsl, po_line_locations_all poll, mtl_units_of_measure muom,

2208:
2209: -- Cursor to lock the ASN supply line record.
2210: CURSOR lock_asn_record(p_uom_code VARCHAR2, p_project_id NUMBER, p_task_id NUMBER) IS
2211: SELECT muom.uom_code, pod.project_id, pod.task_id
2212: FROM rcv_shipment_lines rsl, po_line_locations_all poll, mtl_units_of_measure muom,
2213: (SELECT po_header_id, po_line_id, line_location_id,
2214: MIN(project_id) AS project_id, MIN(task_id) AS task_id
2215: FROM po_distributions_all
2216: WHERE po_header_id = l_supply_header_id

Line 9766: FROM po_line_locations_all poll, wsh_delivery_details wdd,

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

Line 9814: FROM po_line_locations_all poll, wsh_delivery_details wdd,

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