APPS.PJM_TRANSFER_CHARGES_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 168: FROM PO_Distributions_All POD

164: , POL.Item_Id
165: , POD.Po_Header_Id
166: , Null
167: , Null )
168: FROM PO_Distributions_All POD
169: , PO_Lines_All POL
170: WHERE POD.PO_Distribution_Id = X_PO_Distribution_Id
171: AND POL.PO_Line_Id = POD.PO_Line_Id;
172:

Line 181: FROM PO_Distributions_All POD

177: , wo.standard_operation_id
178: , wdj.wip_entity_id
179: , wdj.primary_item_id
180: , wo.department_id )
181: FROM PO_Distributions_All POD
182: , WIP_Discrete_Jobs WDJ
183: , WIP_Operations WO
184: WHERE POD.PO_Distribution_Id = X_PO_Distribution_Id
185: AND WO.WIP_Entity_Id = POD.WIP_Entity_Id

Line 365: PO_Distributions_All POD

361: AND POSTED_FLAG = 'Y'
362: ) DIST,
363: PA_Projects_ALL PAP,
364: PJM_Org_Parameters POP,
365: PO_Distributions_All POD
366: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
367: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
368: AND DIST.Invoice_Id = INV.Invoice_Id
369: AND (( l_Start_Date is null and l_End_Date is null)

Line 436: PO_Distributions_All POD

432: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
433: ) DIST,
434: PA_Projects_ALL PAP,
435: PJM_Org_Parameters POP,
436: PO_Distributions_All POD
437: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
438: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
439: AND DIST.Invoice_Id = INV.Invoice_Id
440: AND (( l_Start_Date is null and l_End_Date is null)

Line 505: PO_Distributions_All POD

501: AND POSTED_FLAG = 'Y'
502: ) DIST,
503: PA_Projects_ALL PAP,
504: PJM_Org_Parameters POP,
505: PO_Distributions_All POD
506: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
507: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
508: AND DIST.Invoice_Id = INV.Invoice_Id
509: AND (( l_Start_Date is null and l_End_Date is null)

Line 577: PO_Distributions_All POD

573: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
574: ) DIST,
575: PA_Projects_ALL PAP,
576: PJM_Org_Parameters POP,
577: PO_Distributions_All POD
578: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
579: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
580: AND DIST.Invoice_Id = INV.Invoice_Id
581: AND (( l_Start_Date is null and l_End_Date is null)

Line 603: FROM po_distributions_all pod

599: SELECT POD.Destination_Type_Code
600: , POL.Item_ID
601: , POD.Bom_Resource_ID Wip_Resource_Id
602: , POD.Destination_Organization_ID
603: FROM po_distributions_all pod
604: , po_lines_all pol
605: WHERE POD.PO_Distribution_ID = P_Distribution_ID
606: AND POL.Po_line_ID = POD.Po_Line_ID;
607: