DBA Data[Home] [Help]

APPS.POS_CHANGE_PROM_DATES dependencies on PO_RELEASES_ALL

Line 177: from po_releases_all por,

173: x_document_type,
174: x_org_id,
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

Line 498: update po_releases_all

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
499: set authorization_status = 'APPROVED'
500: where po_release_id = x_document_id;
501: end if;
502:

Line 605: update po_releases_all set

601: program_id = fnd_global.conc_program_id,
602: program_update_date = sysdate
603: where po_header_id = document_id;
604: else
605: update po_releases_all set
606: authorization_status = 'IN PROCESS',
607: revision_num = revision_num + 1,
608: revised_date = sysdate,
609: last_update_date = sysdate,

Line 767: from po_releases_all por,

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