DBA Data[Home] [Help]

APPS.CST_PACEAMCOST_GRP dependencies on WIP_EAM_DIRECT_ITEMS

Line 495: /* Populate the Global Temp Table that replaces wip_eam_direct_items WEDIV

491: For i in l_wip_entity_id_tab.FIRST..l_wip_entity_id_tab.LAST LOOP
492: l_entity_id_tab(i) := l_wip_entity_id_tab(i);
493: END LOOP;
494:
495: /* Populate the Global Temp Table that replaces wip_eam_direct_items WEDIV
496: Thereafter in this file cst_eam_direct_items_temp CEDIT replaces WEDIV
497: This is done to improve the performance of the cursor queries in estimation*/
498: CST_eamCost_PUB.Insert_tempEstimateDetails (
499: p_api_version => 1.0,

Line 1439: FROM wip_eam_direct_items wedi,

1435: wedi.uom,
1436: NULL,
1437: NULL))),
1438: 0) * NVL(wedi.unit_price, 0) * NVL(cedit.currency_rate,1)), l_ext_precision) wedi_value
1439: FROM wip_eam_direct_items wedi,
1440: cst_eam_direct_items_temp cedit
1441: WHERE wedi.wip_entity_id = p_wip_entity_id
1442: AND cedit.work_order_number(+) = wedi.wip_entity_id
1443: AND cedit.organization_id(+) = wedi.organization_id