DBA Data[Home] [Help]

APPS.PO_CHG_REQUEST_GRP dependencies on PO_LINE_LOCATIONS_ALL

Line 136: from po_line_locations_all plla

132: PO_MOAC_UTILS_PVT.set_org_context(x_org_id) ; --
133:
134: -- added for bug# 5639722
135: select plla.PO_LINE_ID into l_doc_line_id
136: from po_line_locations_all plla
137: where plla.line_location_id = p_po_line_location_id;
138:
139: PO_Document_Control_GRP.check_control_action(
140: p_api_version => 1.0,

Line 846: PO_LINE_LOCATIONS_ALL PLLA,

842: l_closed_code, l_closed_flag, l_old_so_line_number,
843: l_req_status, l_line_price_ovrride,
844: l_shipment_type, l_drop_ship_flag, l_po_curr
845: FROM
846: PO_LINE_LOCATIONS_ALL PLLA,
847: PO_LINES_ALL PLA,
848: FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
849: -- MTL_UNITS_OF_MEASURE_TL MUOMTL,
850: PO_RELEASES_ALL PRAA, PO_HEADERS_ALL PHA,

Line 929: PO_LINE_LOCATIONS_ALL PLLA,

925: l_closed_code, l_closed_flag, l_old_so_line_number,
926: l_req_status,
927: l_shipment_type, l_drop_ship_flag, l_po_curr
928: FROM
929: PO_LINE_LOCATIONS_ALL PLLA,
930: PO_LINES_ALL PLA,
931: FINANCIALS_SYSTEM_PARAMS_ALL FSPA,
932: PO_HEADERS_ALL PHA,
933: PO_CHANGE_REQUESTS POCR