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 383: PO_Distributions_All POD

379: AND POSTED_FLAG = 'Y'
380: ) DIST,
381: PA_Projects_ALL PAP,
382: PJM_Org_Parameters POP,
383: PO_Distributions_All POD
384: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
385: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
386: AND DIST.Invoice_Id = INV.Invoice_Id
387: AND NVL(INV.Source, 'XX' ) <> 'Oracle Project Accounting'

Line 453: PO_Distributions_All POD

449: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
450: ) DIST,
451: PA_Projects_ALL PAP,
452: PJM_Org_Parameters POP,
453: PO_Distributions_All POD
454: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
455: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
456: AND DIST.Invoice_Id = INV.Invoice_Id
457: AND NVL(INV.Source, 'XX' ) <> 'Oracle Project Accounting'

Line 518: PO_Distributions_All POD

514: AND POSTED_FLAG = 'Y'
515: ) DIST,
516: PA_Projects_ALL PAP,
517: PJM_Org_Parameters POP,
518: PO_Distributions_All POD
519: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
520: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
521: AND DIST.Invoice_Id = INV.Invoice_Id
522: AND (( l_Start_Date is null and l_End_Date is null)

Line 590: PO_Distributions_All POD

586: AND (P.charge_applicable_to_dist_id IS NOT NULL OR C.LINE_TYPE_LOOKUP_CODE IN ('FREIGHT','MISCELLANEOUS')) -- bugfix 7482789
587: ) DIST,
588: PA_Projects_ALL PAP,
589: PJM_Org_Parameters POP,
590: PO_Distributions_All POD
591: WHERE INV.INVOICE_TYPE_LOOKUP_CODE <> 'EXPENSE REPORT'
592: AND POD.destination_type_code in ('INVENTORY', 'SHOP FLOOR')
593: AND DIST.Invoice_Id = INV.Invoice_Id
594: AND (( l_Start_Date is null and l_End_Date is null)

Line 616: FROM po_distributions_all pod

612: SELECT POD.Destination_Type_Code
613: , POL.Item_ID
614: , POD.Bom_Resource_ID Wip_Resource_Id
615: , POD.Destination_Organization_ID
616: FROM po_distributions_all pod
617: , po_lines_all pol
618: WHERE POD.PO_Distribution_ID = P_Distribution_ID
619: AND POL.Po_line_ID = POD.Po_Line_ID;
620:

Line 747: FROM PO_DISTRIBUTIONS_ALL

743:
744: -- get wip entity id ,po header id for the PO.
745: SELECT wip_entity_id,po_line_id
746: INTO l_wip_entity_id,l_po_line_id
747: FROM PO_DISTRIBUTIONS_ALL
748: WHERE po_distribution_id = InvRec.PO_Distribution_Id;
749:
750: IF (l_wip_entity_id is not NULL and l_po_line_id is not NULL) THEN
751: Begin

Line 793: FROM PO_DISTRIBUTIONS_ALL POD,

789: /* Bug 13853188 The expenditure organization is not active */
790: Begin
791: SELECT BD.pa_expenditure_org_id
792: INTO l_exp_org_id
793: FROM PO_DISTRIBUTIONS_ALL POD,
794: wip_operations WO ,
795: bom_departments BD
796: WHERE POD.wip_entity_id = WO.wip_entity_id
797: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)

Line 1177: FROM PO_DISTRIBUTIONS_ALL

1173:
1174: -- get wip entity id ,po header id for the PO.
1175: SELECT wip_entity_id,po_line_id
1176: INTO l_wip_entity_id,l_po_line_id
1177: FROM PO_DISTRIBUTIONS_ALL
1178: WHERE po_distribution_id = InvRec.PO_Distribution_Id;
1179:
1180: IF (l_wip_entity_id is not NULL and l_po_line_id is not NULL) THEN
1181: Begin

Line 1224: FROM PO_DISTRIBUTIONS_ALL POD,

1220: /* Bug 13853188 The expenditure organization is not active */
1221: Begin
1222: SELECT BD.pa_expenditure_org_id
1223: INTO l_exp_org_id
1224: FROM PO_DISTRIBUTIONS_ALL POD,
1225: wip_operations WO ,
1226: bom_departments BD
1227: WHERE POD.wip_entity_id = WO.wip_entity_id
1228: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)

Line 1619: FROM PO_DISTRIBUTIONS_ALL

1615:
1616: -- get wip entity id ,po header id for the PO.
1617: SELECT wip_entity_id,po_line_id
1618: INTO l_wip_entity_id,l_po_line_id
1619: FROM PO_DISTRIBUTIONS_ALL
1620: WHERE po_distribution_id = InvRec.PO_Distribution_Id;
1621:
1622: IF (l_wip_entity_id is not NULL and l_po_line_id is not NULL) THEN
1623: Begin

Line 1664: FROM PO_DISTRIBUTIONS_ALL POD,

1660: /* Bug 13853188 The expenditure organization is not active */
1661: Begin
1662: SELECT BD.pa_expenditure_org_id
1663: INTO l_exp_org_id
1664: FROM PO_DISTRIBUTIONS_ALL POD,
1665: wip_operations WO ,
1666: bom_departments BD
1667: WHERE POD.wip_entity_id = WO.wip_entity_id
1668: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)

Line 2048: FROM PO_DISTRIBUTIONS_ALL

2044:
2045: -- get wip entity id ,po header id for the PO.
2046: SELECT wip_entity_id,po_line_id
2047: INTO l_wip_entity_id,l_po_line_id
2048: FROM PO_DISTRIBUTIONS_ALL
2049: WHERE po_distribution_id = InvRec.PO_Distribution_Id;
2050:
2051: IF (l_wip_entity_id is not NULL and l_po_line_id is not NULL) THEN
2052: Begin

Line 2092: FROM PO_DISTRIBUTIONS_ALL POD,

2088: /* Bug 13853188 The expenditure organization is not active */
2089: Begin
2090: SELECT BD.pa_expenditure_org_id
2091: INTO l_exp_org_id
2092: FROM PO_DISTRIBUTIONS_ALL POD,
2093: wip_operations WO ,
2094: bom_departments BD
2095: WHERE POD.wip_entity_id = WO.wip_entity_id
2096: AND NVL(wo.repetitive_schedule_id, -99999) = NVL(POD.wip_repetitive_schedule_id, -99999)