DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on WIP_EAM_DIRECT_ITEMS

Line 2977: FROM wip_eam_direct_items wedi,

2973: 0
2974: ) * NVL(wedi.unit_price, 0) * NVL(wediv.currency_rate,1)),
2975: l_ext_precision
2976: ) wedi_value
2977: FROM wip_eam_direct_items wedi,
2978: cst_eam_direct_items_temp wediv
2979: WHERE wedi.wip_entity_id = p_wip_entity_id
2980: AND wediv.work_order_number(+) = wedi.wip_entity_id
2981: AND wediv.organization_id(+) = wedi.organization_id

Line 4800: FROM wip_eam_direct_items wedi,

4796: p_request_id,
4797: p_prog_app_id,
4798: p_prog_id,
4799: SYSDATE
4800: FROM wip_eam_direct_items wedi,
4801: cst_eam_direct_items_temp cedi
4802: WHERE wedi.wip_entity_id = p_wip_entity_id
4803: AND cedi.work_order_number(+) = wedi.wip_entity_id
4804: AND cedi.direct_item_sequence_id(+) = wedi.direct_item_sequence_id

Line 10627: wip_eam_direct_items wed,

10623: FROM
10624: po_line_types plt,
10625: mtl_units_of_measure uom,
10626: po_headers_all poh,
10627: wip_eam_direct_items wed,
10628: hr_organization_information hoi,
10629: wip_operations wo,
10630: (SELECT
10631: pd1.wip_entity_id,

Line 10807: wip_eam_direct_items wed,

10803: po_requisition_lines_all rql,
10804: po_requisition_headers_all rqh,
10805: po_line_types plt,
10806: mtl_units_of_measure uom,
10807: wip_eam_direct_items wed,
10808: hr_organization_information hoi,
10809: wip_operations wo
10810: WHERE
10811: rql.requisition_header_id = rqh.requisition_header_id AND