DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on POS_TOTALS_PO_SV

Line 3309: select segment1, revision_num, pos_totals_po_sv.get_po_total(po_header_id), currency_code,

3305: end if;
3306:
3307: if(l_release_id is null) then
3308: l_document_type := fnd_message.get_string('PO','PO_WF_NOTIF_STD_PO');
3309: select segment1, revision_num, pos_totals_po_sv.get_po_total(po_header_id), currency_code,
3310: vendor_id, vendor_site_id, creation_date, fob_lookup_code,
3311: ship_via_lookup_code, ship_to_location_id, acceptance_required_flag,type_lookup_code
3312: into
3313: l_po_num, l_revision_num, l_po_total, l_po_currency,

Line 3336: select ph.segment1, pr.release_num, pr.revision_num, pos_totals_po_sv.get_release_total(pr.po_release_id), ph.currency_code,

3332: l_po_doc_id := -1;
3333: end if;
3334: else
3335:
3336: select ph.segment1, pr.release_num, pr.revision_num, pos_totals_po_sv.get_release_total(pr.po_release_id), ph.currency_code,
3337: ph.vendor_id, ph.vendor_site_id, pr.creation_date, ph.fob_lookup_code,
3338: ph.ship_via_lookup_code, ph.ship_to_location_id, pr.acceptance_required_flag,ph.type_lookup_code
3339: into
3340: l_blanket_num, l_release_num, l_revision_num, l_po_total, l_po_currency,