APPS.CST_EAMCOST_PUB dependencies on WIP_ENTITIES

Line 265: FROM wip_entities we

261: FROM wip_transactions wt
262: WHERE wt.group_id = p_group_id
263: AND EXISTS
264: (SELECT 'eam jobs'
265: FROM wip_entities we
266: WHERE we.wip_entity_id = wt.wip_entity_id
267: AND we.entity_type in (6,7));
268:
269: BEGIN

Line 560: FROM wip_entities we

556: l_stmt_num := 60;
557:
558: SELECT we.entity_type
559: INTO l_wip_entity_type
560: FROM wip_entities we
561: WHERE we.wip_entity_id = p_wip_entity_id;
562:
563: IF l_wip_entity_type not in (6,7) THEN
564: l_api_message := 'Job is not eAM job.';

Line 1817: FROM wip_entities we

1813: SELECT entity_type,
1814: organization_id
1815: INTO l_entity_type,
1816: l_organization_id
1817: FROM wip_entities we
1818: WHERE we.wip_entity_id = p_wip_entity_id;
1819:
1820: -- Check for existence of operation. If a job has a bill but no routing,
1821: -- component requirements will not have a department associated to it.

Line 2949: FROM wip_entities we

2945: SELECT entity_type,
2946: organization_id
2947: INTO l_entity_type,
2948: l_organization_id
2949: FROM wip_entities we
2950: WHERE we.wip_entity_id = p_wip_entity_id;
2951:
2952:
2953: IF (l_entity_type NOT IN (1,6)) THEN

Line 5720: FROM wip_entities

5716: -- Get entity type for the job
5717: l_stmt_num := 50;
5718: SELECT nvl(entity_type,-1)
5719: INTO l_entity_type
5720: FROM wip_entities
5721: WHERE wip_entity_id = l_wip_entity_id;
5722:
5723: if (l_debug = 'Y') then
5724: fnd_file.put_line(fnd_file.log,'Entity: ' || to_char(l_entity_type));

Line 6253: from wip_entities

6249: entity_type
6250: into l_directItem_rec.primary_item_id,
6251: l_directItem_rec.wip_entity_name,
6252: l_directItem_rec.entity_type
6253: from wip_entities
6254: where wip_entity_id = l_directItem_rec.wip_entity_id;
6255:
6256: if (l_debug = 'Y') then
6257: fnd_file.put_line(fnd_file.log,'Job Name : ' || l_directItem_rec.wip_entity_name);

Line 7649: from wip_entities

7645: ---------------------------------------------
7646: l_statement := 45;
7647: select entity_type
7648: into l_entity_type
7649: from wip_entities
7650: where wip_entity_id = p_wip_entity_id;
7651:
7652: if (l_entity_type in (6,7)) then
7653: ---------------------------------------------

Line 7952: wip_entities we,

7948: wdj.task_id,
7949: wdj.maintenance_object_id
7950: from wip_cost_txn_interface wcti,
7951: wip_discrete_jobs wdj,
7952: wip_entities we,
7953: csi_item_instances cii
7954: where wcti.group_id = p_wcti_group_id
7955: and wdj.wip_entity_id = wcti.wip_entity_id
7956: and we.wip_entity_id = wcti.wip_entity_id