DBA Data[Home] [Help]

APPS.PO_FED_FIELD_FUNCTIONS dependencies on PO_LINE_LOCATIONS_ALL

Line 3098: FROM po_line_locations_all

3094: BEGIN
3095:
3096: SELECT SHIP_TO_LOCATION_ID
3097: INTO l_ship_to_loc_id
3098: FROM po_line_locations_all
3099: WHERE LINE_LOCATION_ID = p_line_loc_id;
3100:
3101: SELECT ADDRESS_LINE_1, ADDRESS_LINE_2, TOWN_OR_CITY, REGION_2, STYLE, POSTAL_CODE,COUNTRY
3102: INTO l_addr_line_1, l_addr_line_2, l_town_or_city, l_region2, l_style, l_postal_code,p_hiddenCountry

Line 3730: po_line_locations_all poll,

3726: INTO l_count
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