APPS.PO_FED_FIELD_FUNCTIONS dependencies on PO_HEADERS_ALL

Line 2725: FROM po_headers_all

2721: BEGIN
2722: IF(draft_id IS NULL OR draft_id = -1 OR draft_id = 0) THEN
2723: SELECT vendor_id,vendor_site_id,vendor_contact_id
2724: INTO l_supplier_id,l_supplier_site_id,l_contact_id
2725: FROM po_headers_all
2726: WHERE po_header_id = l_po_header_id;
2727:
2728: ELSE
2729: SELECT vendor_id,vendor_site_id,vendor_contact_id

Line 2867: FROM po_headers_all poh

2863: IF l_ccr_reg_status = 'E' OR p_ccr_reg_idictr ='No' THEN
2864: IF(draft_id IS NULL OR draft_id = -1 OR draft_id = 0) THEN
2865: SELECT clm_special_contract_type
2866: INTO l_clm_special_cont_type
2867: FROM po_headers_all poh
2868: WHERE poh.po_header_id = l_po_header_id;
2869: END IF;
2870: -- Get CCR exception reason from global contract type object in PO_DRAFTS_PVT
2871: IF l_clm_special_cont_type IS NOT NULL THEN

Line 3731: po_headers_all poh

3727: FROM ap_invoice_distributions_all aid,
3728: ap_invoices_all aia,
3729: po_distributions_all pod,
3730: po_line_locations_all poll,
3731: po_headers_all poh
3732: WHERE poh.po_header_id = l_po_header_id
3733: and nvl(poh.authorization_status, 'INCOMPLETE') = 'APPROVED'
3734: and poll.po_header_id = poh.po_header_id
3735: AND nvl(poll.closed_code,'OPEN') <> 'CLOSED FOR INVOICE'