DBA Data[Home] [Help]

APPS.POS_CREATE_ASN dependencies on PO_HEADERS_ALL

Line 122: from po_headers_all

118: -- Get org context for the PO
119: BEGIN
120: select org_id
121: into l_org_id
122: from po_headers_all
123: where po_header_id = p_po_header_id_t;
124: EXCEPTION
125: WHEN NO_DATA_FOUND THEN
126: raise_application_error(-20001,'Org Id not found for ' || to_char(p_po_header_id_t));

Line 520: from po_headers_all

516: */
517:
518: select agent_id
519: into l_buyer_id
520: from po_headers_all
521: where po_header_id = p_po_header_id_t;
522:
523: select count(*)
524: into x_note_count

Line 761: FROM PO_HEADERS_ALL POH,

757: x_return_status => l_return_status);
758:
759: SELECT Nvl(PDSH.CLM_FLAG,'N') CLM_FLAG
760: INTO l_clm_flag
761: FROM PO_HEADERS_ALL POH,
762: PO_LINE_LOCATIONS_ALL POLL,
763: PO_DOC_STYLE_HEADERS PDSH
764: WHERE POLL.LINE_LOCATION_ID = l_line_location_id AND
765: POLL.PO_HEADER_ID = POH.PO_HEADER_ID AND

Line 955: from po_headers_all

951: group by rti.header_interface_id;
952:
953: select org_id
954: into l_org_id
955: from po_headers_all
956: where po_header_id = l_po_header_id;
957:
958: fnd_client_info.set_org_context(to_char(l_org_id));
959: