APPS.POS_CHANGE_PROM_DATES dependencies on PO_HEADERS_ALL

Line 179: po_headers_all poh

175: x_document_num,
176: x_agent_id
177: from po_releases_all por,
178: po_lookup_codes polc,
179: po_headers_all poh
180: where po_release_id = x_po_release_id
181: and por.po_header_id=poh.po_header_id
182: and por.release_type = polc.lookup_code
183: and polc.lookup_type = 'DOCUMENT SUBTYPE';

Line 191: from po_headers_all poh,

187: else
188:
189: select poh.segment1, poh.agent_id, poh.type_lookup_code, polc.displayed_field, poh.org_id
190: into x_document_num, x_agent_id, x_document_subtype, x_document_type, x_org_id
191: from po_headers_all poh,
192: po_lookup_codes polc
193: where
194: poh.po_header_id = x_document_id
195: and poh.type_lookup_code = polc.lookup_code

Line 494: update po_headers_all

490: x_document_type_code := wf_engine.GetItemAttrText ( itemtype => itemtype,
491: itemkey => itemkey,
492: aname => 'DOCUMENT_TYPE_CODE');
493: if x_document_type_code <> 'RELEASE' then
494: update po_headers_all
495: set authorization_status = 'APPROVED'
496: where po_header_id = x_document_id;
497: else
498: update po_releases_all

Line 592: update po_headers_all set

588: initialize (x_employee_id, x_org_id);
589:
590: if NVL(DocumentTypeCode, 'PO') <> 'RELEASE' then
591:
592: update po_headers_all set
593: authorization_status = 'IN PROCESS',
594: revision_num = revision_num + 1,
595: revised_date = sysdate,
596: last_update_date = sysdate,

Line 751: from po_headers_all poh,

747: DECODE(poll.SHIPMENT_TYPE, 'PRICE BREAK', NULL,
748: poll.QUANTITY - poll.QUANTITY_CANCELLED),pv.vendor_name
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

Line 771: po_headers_all poh

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
774: and pol.po_line_id = poll.po_line_id
775: and poll.po_release_id = por.po_release_id