APPS.POS_CHANGE_PROM_DATES dependencies on PO_LINE_LOCATIONS_ALL

Line 161: from po_line_locations_all

157: itemkey => itemkey,
158: aname => 'LINE_LOC_ID1');
159:
160: select po_release_id into x_po_release_id
161: from po_line_locations_all
162: where line_location_id = X_line_loc_id1;
163:
164: if x_po_release_id is not null then
165: -- shipment for a release

Line 753: po_line_locations_all poll,

749: into x_agent_id, x_item_id, x_ship_to_organization_id,x_line_num,
750: x_uom,x_item_description,x_qty_ordered,x_vendor_name
751: from po_headers_all poh,
752: po_lines_all pol,
753: po_line_locations_all poll,
754: po_vendors pv
755: where
756: poll.line_location_id = x_line_location_id
757: and pol.po_line_id = poll.po_line_id

Line 769: po_line_locations_all poll,

765: into x_agent_id, x_item_id, x_ship_to_organization_id,x_line_num,
766: x_uom,x_item_description,x_qty_ordered,x_vendor_name
767: from po_releases_all por,
768: po_lines_all pol,
769: po_line_locations_all poll,
770: po_vendors pv,
771: po_headers_all poh
772: where
773: poll.line_location_id = x_line_location_id

Line 1197: UPDATE po_line_locations_all

1193: aname => 'NEW_PROMISED_DATE');
1194:
1195: initialize(x_employee_id, x_org_id);
1196:
1197: UPDATE po_line_locations_all
1198: SET promised_date = x_new_date,
1199: last_update_date = sysdate,
1200: last_updated_by = fnd_global.user_id,
1201: last_update_login = fnd_global.login_id,

Line 1267: UPDATE po_line_locations_all

1263: x_new_needby_date := wf_engine.GetItemAttrDate ( itemtype => itemtype,
1264: itemkey => itemkey,
1265: aname => 'NEW_NEEDBY_DATE');
1266:
1267: UPDATE po_line_locations_all
1268: SET promised_date = x_new_promised_date,
1269: need_by_date = x_new_needby_date,
1270: last_update_date = sysdate,
1271: last_updated_by = fnd_global.user_id,