APPS.PO_CREATE_ISO dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 138: from PO_LOCATION_ASSOCIATIONS_ALL PLA

134: nvl(org.operating_unit,-1),
135: hdr.requisition_header_id,
136: lin.requisition_line_id,
137: Nvl((select PLA.CUSTOMER_ID
138: from PO_LOCATION_ASSOCIATIONS_ALL PLA
139: where pla.location_id = lin.deliver_to_location_id
140: AND nvl(PLA.ORG_ID,-1) = nvl(org.operating_unit,-1)
141: AND rownum=1),-1) customer_id --bug 8692047
142: from po_requisition_lines lin,

Line 356: PO_LOCATION_ASSOCIATIONS_ALL PLA

352: decode(l_op_unit_id, -1, NULL, l_op_unit_id) ,
353: 'ARRIVAL' --Bug 7662103:
354: FROM PO_REQUISITION_HEADERS RH,
355: PO_REQUISITION_LINES RL,
356: PO_LOCATION_ASSOCIATIONS_ALL PLA
357: WHERE RH.REQUISITION_HEADER_ID = RL.REQUISITION_HEADER_ID
358: AND RL.DELIVER_TO_LOCATION_ID = PLA.LOCATION_ID
359: AND nvl(PLA.ORG_ID,-1) = l_op_unit_id
360: AND RL.REQUISITION_LINE_ID = l_req_line_id;

Line 388: PO_LOCATION_ASSOCIATIONS_ALL PLA

384: Begin
385: SELECT PLA.CUSTOMER_ID
386: INTO l_customer_id
387: FROM PO_REQUISITION_LINES RL,
388: PO_LOCATION_ASSOCIATIONS_ALL PLA
389: WHERE RL.DELIVER_TO_LOCATION_ID = PLA.LOCATION_ID
390: AND nvl(PLA.ORG_ID,-1) = l_op_unit_id
391: AND RL.REQUISITION_LINE_ID = l_req_line_id;
392: Exception

Line 743: PO_LOCATION_ASSOCIATIONS_ALL LA,

739: FROM PO_REQUISITION_LINES RL,
740: PO_REQUISITION_HEADERS RH,
741: PO_REQ_DISTRIBUTIONS RD, --only one distribution allowed!
742: MTL_SYSTEM_ITEMS SI,
743: PO_LOCATION_ASSOCIATIONS_ALL LA,
744: MTL_UNITS_OF_MEASURE MUM
745: --,MTL_UNITS_OF_MEASURE MUM1
746: WHERE RL.REQUISITION_LINE_ID = RD.REQUISITION_LINE_ID
747: AND RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID