APPS.PO_CREATE_ISO dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 292: PO_LOCATION_ASSOCIATIONS_ALL PLA

288: decode(l_op_unit_id, -1, NULL, l_op_unit_id) ,
289: 'ARRIVAL' --Bug 7662103:
290: FROM PO_REQUISITION_HEADERS RH,
291: PO_REQUISITION_LINES RL,
292: PO_LOCATION_ASSOCIATIONS_ALL PLA
293: WHERE RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID
294: AND RL.DELIVER_TO_LOCATION_ID = PLA.LOCATION_ID
295: AND nvl(PLA.ORG_ID,-1) = l_op_unit_id
296: AND RL.REQUISITION_LINE_ID = l_req_line_id;

Line 322: PO_LOCATION_ASSOCIATIONS_ALL PLA

318: Begin
319: SELECT PLA.CUSTOMER_ID
320: INTO l_customer_id
321: FROM PO_REQUISITION_LINES RL,
322: PO_LOCATION_ASSOCIATIONS_ALL PLA
323: WHERE RL.DELIVER_TO_LOCATION_ID = PLA.LOCATION_ID
324: AND nvl(PLA.ORG_ID,-1) = l_op_unit_id
325: AND RL.REQUISITION_LINE_ID = l_req_line_id;
326: Exception

Line 611: PO_LOCATION_ASSOCIATIONS_ALL LA,

607: FROM PO_REQUISITION_LINES RL,
608: PO_REQUISITION_HEADERS RH,
609: PO_REQ_DISTRIBUTIONS RD, --only one distribution allowed!
610: MTL_SYSTEM_ITEMS SI,
611: PO_LOCATION_ASSOCIATIONS_ALL LA,
612: MTL_UNITS_OF_MEASURE MUM
613: --,MTL_UNITS_OF_MEASURE MUM1
614: WHERE RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID
615: AND RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID