APPS.PO_DELREC_PVT dependencies on PO_HEADERS_ALL

Line 181: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;

177: )
178: IS
179: l_api_name CONSTANT VARCHAR2(100) := 'create_update_delrec';
180: l_api_version CONSTANT NUMBER := 1.0;
181: l_shipping_control PO_HEADERS_ALL.shipping_control%TYPE;
182:
183: -- define record of tables for bulk processing
184: l_action_rec WSH_BULK_TYPES_GRP.action_parameters_rectype;
185: l_fte_rec OE_WSH_BULK_GRP.Line_Rec_Type;

Line 300: FROM PO_HEADERS_ALL

296:
297: IF ( p_doc_type = 'PO' AND p_doc_subtype = 'STANDARD' ) THEN
298: SELECT shipping_control
299: INTO l_shipping_control
300: FROM PO_HEADERS_ALL
301: WHERE po_header_id = p_doc_id;
302: ELSIF ( p_doc_type = 'RELEASE' AND p_doc_subtype = 'BLANKET') THEN
303: SELECT shipping_control
304: INTO l_shipping_control

Line 870: po_headers_all poh,

866: x_fte_rec.rcv_supplier_item_num,
867: x_fte_rec.rcv_preferred_grade,
868: x_fte_rec.asn_type
869: FROM
870: po_headers_all poh,
871: po_lines_all pol,
872: po_line_locations_all pll,
873: rcv_transactions rt,
874: mtl_system_items msi,

Line 1165: po_headers_all poh,

1161: x_fte_rec.rcv_supplier_item_num,
1162: x_fte_rec.rcv_preferred_grade,
1163: x_fte_rec.asn_type
1164: FROM
1165: po_headers_all poh,
1166: po_lines_all pol,
1167: po_line_locations_all pll,
1168: rcv_transactions rt,
1169: mtl_system_items msi,