DBA Data[Home] [Help]

APPS.CSTPPCIC dependencies on CST_PAC_ITEM_COST_DETAILS

Line 566: FROM cst_pac_item_cost_details cpicd,

562: AND p_range = 5)
563: )
564: AND EXISTS
565: (SELECT NULL
566: FROM cst_pac_item_cost_details cpicd,
567: cst_pac_item_costs cpic
568: WHERE cpicd.cost_layer_id = cpic.cost_layer_id
569: AND cpic.cost_group_id = p_from_cost_group_id
570: AND cpic.pac_period_id = p_period_id

Line 899: cst_pac_item_cost_details CPICD,

895: , 702
896: , l_program_id
897: , SYSDATE
898: FROM cst_pac_item_costs CPIC,
899: cst_pac_item_cost_details CPICD,
900: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items
901: WHERE CPIC.pac_period_id = p_period_id
902: AND CPIC.cost_group_id = p_from_cost_group_id
903: AND CPIC.cost_layer_id = CPICD.cost_layer_id

Line 1172: cst_pac_item_cost_details CPICD,

1168: , 702
1169: , l_program_id
1170: , SYSDATE
1171: FROM cst_pac_item_costs CPIC,
1172: cst_pac_item_cost_details CPICD,
1173: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items
1174: WHERE CPIC.pac_period_id = p_period_id
1175: AND CPIC.cost_group_id = p_from_cost_group_id
1176: AND CPIC.cost_layer_id = CPICD.cost_layer_id

Line 1581: cst_pac_item_cost_details CPICD,

1577: , 702
1578: , l_program_id
1579: , SYSDATE
1580: FROM cst_pac_item_costs CPIC,
1581: cst_pac_item_cost_details CPICD,
1582: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items
1583: WHERE CPIC.pac_period_id = p_period_id
1584: AND CPIC.cost_group_id = p_from_cost_group_id
1585: AND CPIC.cost_layer_id = CPICD.cost_layer_id