APPS.CST_EAMCOST_PUB dependencies on WIP_ENTITIES

Line 466: FROM wip_entities we

462: FROM wip_transactions wt
463: WHERE wt.group_id = p_group_id
464: AND EXISTS
465: (SELECT 'eam jobs'
466: FROM wip_entities we
467: WHERE we.wip_entity_id = wt.wip_entity_id
468: AND we.entity_type in (6,7));
469:
470: BEGIN

Line 762: FROM wip_entities we

758: l_stmt_num := 60;
759:
760: SELECT we.entity_type
761: INTO l_wip_entity_type
762: FROM wip_entities we
763: WHERE we.wip_entity_id = p_wip_entity_id;
764:
765: IF l_wip_entity_type not in (6,7) THEN
766: l_api_message := 'Job is not eAM job.';

Line 2039: FROM wip_entities we

2035: SELECT entity_type,
2036: organization_id
2037: INTO l_entity_type,
2038: l_organization_id
2039: FROM wip_entities we
2040: WHERE we.wip_entity_id = p_wip_entity_id;
2041:
2042: -- Check for existence of operation. If a job has a bill but no routing,
2043: -- component requirements will not have a department associated to it.

Line 3171: FROM wip_entities we

3167: SELECT entity_type,
3168: organization_id
3169: INTO l_entity_type,
3170: l_organization_id
3171: FROM wip_entities we
3172: WHERE we.wip_entity_id = p_wip_entity_id;
3173:
3174:
3175: IF (l_entity_type NOT IN (1,6)) THEN

Line 6016: FROM wip_entities

6012: -- Get entity type for the job
6013: l_stmt_num := 50;
6014: SELECT nvl(entity_type,-1)
6015: INTO l_entity_type
6016: FROM wip_entities
6017: WHERE wip_entity_id = l_wip_entity_id;
6018:
6019: if (l_debug = 'Y') then
6020: fnd_file.put_line(fnd_file.log,'Entity: ' || to_char(l_entity_type));

Line 6607: from wip_entities

6603: entity_type
6604: into l_directItem_rec.primary_item_id,
6605: l_directItem_rec.wip_entity_name,
6606: l_directItem_rec.entity_type
6607: from wip_entities
6608: where wip_entity_id = l_directItem_rec.wip_entity_id;
6609:
6610: if (l_debug = 'Y') then
6611: fnd_file.put_line(fnd_file.log,'Job Name : ' || l_directItem_rec.wip_entity_name);

Line 8222: from wip_entities

8218: ---------------------------------------------
8219: l_statement := 45;
8220: select entity_type
8221: into l_entity_type
8222: from wip_entities
8223: where wip_entity_id = p_wip_entity_id;
8224:
8225: if (l_entity_type in (6,7)) then
8226: ---------------------------------------------

Line 8525: wip_entities we,

8521: wdj.task_id,
8522: wdj.maintenance_object_id
8523: from wip_cost_txn_interface wcti,
8524: wip_discrete_jobs wdj,
8525: wip_entities we,
8526: csi_item_instances cii
8527: where wcti.group_id = p_wcti_group_id
8528: and wdj.wip_entity_id = wcti.wip_entity_id
8529: and we.wip_entity_id = wcti.wip_entity_id

Line 11480: FROM wip_entities we

11476: , wac.overhead_account overhead_account
11477: , wac.encumbrance_account wac_encumbrance_account
11478: , msi.encumbrance_account msi_encumbrance_account
11479: , mp.encumbrance_account mp_encumbrance_account
11480: FROM wip_entities we
11481: , wip_discrete_jobs wdj
11482: , wip_accounting_classes wac
11483: , mtl_system_items msi
11484: , mtl_parameters mp