APPS.CST_PACEAMCOST_GRP dependencies on CST_EAM_DIRECT_ITEMS_TEMP

Line 486: DELETE FROM cst_eam_direct_items_temp;

482:
483: l_stmt_num := 67;
484:
485: /* Delete from the global temp table just to make sure it is empty */
486: DELETE FROM cst_eam_direct_items_temp;
487:
488: l_stmt_num := 68;
489:
490: /* Copying data to another table type as need to call perpetual est package */

Line 496: Thereafter in this file cst_eam_direct_items_temp CEDIT replaces WEDIV

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,
500: x_return_status => l_return_status,

Line 1379: FROM cst_eam_direct_items_temp ced,

1375: ) quantity_ordered
1376: /* We convert to primary_uom because the required_quantity in WRO is
1377: always in the primary unit of measure. Sum is needed because there
1378: could be multiple POs/Reqs for the same non-stockable item */
1379: FROM cst_eam_direct_items_temp ced,
1380: mtl_system_items_b msi
1381: WHERE ced.item_id = msi.inventory_item_id
1382: AND ced.organization_id = msi.organization_id
1383: AND ced.work_order_number = p_wip_entity_id

Line 1440: cst_eam_direct_items_temp cedit

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
1444: AND cedit.direct_item_sequence_id(+) = wedi.direct_item_sequence_id

Line 1478: cst_eam_direct_items_temp cedit

1474: FROM po_distributions_all pda,
1475: po_line_locations_all plla,
1476: po_headers_all pha,
1477: po_lines_all pla,
1478: cst_eam_direct_items_temp cedit
1479: WHERE cedit.work_order_number = p_wip_entity_id
1480: AND cedit.organization_id = l_organization_id
1481: AND cedit.task_number = pda.wip_operation_seq_num
1482: AND cedit.category_id = pla.category_id

Line 1507: cst_eam_direct_items_temp cedit

1503: prla.category_id category_id,
1504: prha.last_update_date category_date
1505: FROM po_requisition_lines_all prla,
1506: po_requisition_headers_all prha,
1507: cst_eam_direct_items_temp cedit
1508: WHERE cedit.work_order_number = p_wip_entity_id
1509: AND cedit.organization_id = l_organization_id
1510: AND cedit.task_number = prla.wip_operation_seq_num
1511: AND cedit.category_id = prla.category_id