APPS.PO_XML_DELIVERY dependencies on PO_RELEASES_ALL

Line 104: from po_headers_all poh,po_releases_all por

100:
101: select por.revision_num,poh.vendor_id,poh.vendor_site_id,
102: poh.po_header_id
103: into l_revision_num,l_vendor_id ,l_vendor_site_id,l_doc_id
104: from po_headers_all poh,po_releases_all por
105: where poh.po_header_id=por.po_header_id
106: and por.po_release_id = l_doc_rel_id;
107: elsif (l_doc_type = 'PO' or l_doc_type = 'STANDARD') then --for standard POs.
108: select revision_num,vendor_id,vendor_site_id

Line 205: from po_headers_all poh,po_releases_all por

201: select poh.segment1 || ':' || to_char(por.release_num), poh.org_id,
202: poh.vendor_id, poh.vendor_site_id, poh.comments,poh.creation_date
203: into l_po_number, l_org_id, l_party_id, l_party_site_id, l_po_desc,
204: l_doc_creation_date
205: from po_headers_all poh,po_releases_all por
206: where poh.po_header_id=por.po_header_id
207: and por.po_release_id = l_doc_rel_id;
208:
209: l_po_subtype := 'RELEASE';

Line 436: from po_headers_all poh,po_releases_all por

432:
433: select por.revision_num,poh.vendor_id,poh.vendor_site_id,
434: poh.po_header_id, por.cancel_flag
435: into l_revision_num,l_vendor_id ,l_vendor_site_id,l_doc_id, l_cancel_flag --B4407795,reading cancel flag
436: from po_headers_all poh,po_releases_all por
437: where poh.po_header_id=por.po_header_id
438: and por.po_release_id = l_doc_rel_id;
439:
440:

Line 763: from po_headers_all poh,po_releases_all por

759: l_doc_rel_id := l_doc_id;
760:
761:
762: select por.xml_flag,poh.agent_id into l_xml_flag, l_agent_id
763: from po_headers_all poh,po_releases_all por
764: where poh.po_header_id=por.po_header_id
765: and por.po_release_id = l_doc_rel_id;
766:
767: elsif (l_doc_type = 'STANDARD' or l_doc_type = 'PO') then --for standard POs.

Line 828: update po_releases_all

824: latest_external_flag = 'Y';
825: end if;
826: else
827: if(p_txn_type = 'PRO') then
828: update po_releases_all
829: set xml_send_date = sysdate
830: where
831: po_header_id = p_header_id and
832: po_release_id = p_release_id and

Line 844: update po_releases_all

840: org_id = p_org_id and
841: revision_num = 0;
842:
843: elsif(p_txn_type = 'POCO') then
844: update po_releases_all
845: set xml_change_send_date = sysdate
846: where
847: po_header_id = p_header_id and
848: po_release_id = p_release_id and

Line 949: from po_releases_all

945: end if;
946: else
947: select xml_change_send_date, xml_send_date into
948: l_poco_date, l_pro_date
949: from po_releases_all
950: where po_header_id = p_header_id
951: and po_release_id = p_release_id;
952: if(l_poco_date is not null) then
953: out_date := l_poco_date;

Line 1126: from ap_cards_all aca, ap_card_programs_all acpa, po_releases_all pra

1122: else
1123: select aca.card_number, aca.cardmember_name,aca.card_expiration_date,
1124: acpa.card_brand_lookup_code
1125: into p_card_num, p_card_name, p_card_exp_date, p_card_brand
1126: from ap_cards_all aca, ap_card_programs_all acpa, po_releases_all pra
1127: where pra.po_header_id = p_header_id
1128: and pra.po_release_id = p_release_id
1129: and pra.pcard_id = aca.card_id
1130: and aca.card_program_id = acpa.card_program_id;

Line 1142: from ap_card_suppliers_all acsa, po_releases_all pra

1138: and po_header_id = p_header_id;
1139: else
1140: select count(1)
1141: into is_supplier_pcard
1142: from ap_card_suppliers_all acsa, po_releases_all pra
1143: where acsa.card_id = pra.pcard_id
1144: and pra.po_header_id = p_header_id
1145: and pra.po_release_id = p_release_id;
1146: end if;