APPS.PO_CHANGE_RESPONSE_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 92: FROM po_change_requests PCR, po_distributions_all POD

88: PCR.WF_Item_type, PCR.WF_Item_key, PCR.Parent_Change_Request_Id,
89: PCR.Validation_Error, PCR.Approval_Required_Flag,
90: PCR.Old_Supplier_Order_Number, PCR.New_Supplier_Order_Number,
91: PCR.Old_Supplier_Order_Line_Number, PCR.New_Supplier_Order_Line_Number,PCR.Old_Amount,PCR.New_Amount
92: FROM po_change_requests PCR, po_distributions_all POD
93: WHERE PCR.change_request_id = l_change_request_id
94: AND POD.line_location_id =
95: NVL(PCR.document_line_location_id, PCR.parent_line_location_id);
96:

Line 341: from po_distributions_all where line_location_id = p_document_line_location_id;

337:
338: if ((p_parent_line_location_id is null) OR (p_parent_line_location_id = 0)) then
339:
340: select count(*) into l_distribution_count
341: from po_distributions_all where line_location_id = p_document_line_location_id;
342:
343: else /* line is a split shipment */
344:
345: select count(*) into l_distribution_count

Line 346: from po_distributions_all where line_location_id = p_parent_line_location_id;

342:
343: else /* line is a split shipment */
344:
345: select count(*) into l_distribution_count
346: from po_distributions_all where line_location_id = p_parent_line_location_id;
347:
348: end if; /* split shipment test */
349:
350: end if;