DBA Data[Home] [Help]

APPS.PA_WORK_TYPE_UPGRADE dependencies on PO_DISTRIBUTIONS_ALL

Line 566: Po_Distributions_All PoDist,

562: decode(PoDist.destination_type_code, 'SHOP FLOOR', PoDist.Bom_Resource_Id, null) Wip_Resource_ID ,
563: 'DOLLARS' UOM ,
564: Temp.Pk1_Id
565: FROM Pa_Txn_Upgrade_Temp Temp,
566: Po_Distributions_All PoDist,
567: Po_Lines_All PoLine
568: WHERE Temp.Worker_Id = p_worker_id
569: AND Temp.Pk2_Id = PoDist.po_distribution_id
570: AND PoDist.Po_Line_Id = PoLine.Po_Line_Id