APPS.AHL_WIP_JOB_PVT dependencies on WIP_ENTITIES

Line 33: FROM wip_entities

29: AND interface_id = c_interface_id;
30:
31: CURSOR get_wip_entity(c_wip_entity_name VARCHAR2, c_organization_id NUMBER) IS
32: SELECT wip_entity_id
33: FROM wip_entities
34: WHERE wip_entity_name = c_wip_entity_name
35: AND organization_id = c_organization_id;
36:
37: -- Declare and define local procedure insert_job_header --

Line 141: FROM wip_entities

137: l_wip_job_rec.class_code
138: FROM wip_discrete_jobs
139: WHERE wip_entity_id =
140: ( SELECT wip_entity_id
141: FROM wip_entities
142: WHERE wip_entity_name = p_ahl_wo_rec.wo_name );
143:
144: ELSE
145: l_wip_job_rec.rebuild_item_id := p_ahl_wo_rec.inventory_item_id;

Line 1182: FROM wip_entities

1178: l_org_code get_org_code%ROWTYPE;
1179: CURSOR get_job_attr (c_wip_entity_id NUMBER) IS
1180: -- fix for bug# 3161312.
1181: /*SELECT organization_id, wip_entity_name, entity_type
1182: FROM wip_entities
1183: WHERE wip_entity_id = c_wip_entity_id;*/
1184:
1185: SELECT WDJ.project_id project_id,
1186: WDJ.task_id task_id,

Line 1191: wip_entities WE

1187: WE.organization_id organization_id,
1188: WE.wip_entity_name wip_entity_name,
1189: WE.entity_type entity_type
1190: FROM wip_discrete_jobs WDJ,
1191: wip_entities WE
1192: WHERE WDJ.wip_entity_id = WE.wip_entity_id
1193: AND WE.wip_entity_id = c_wip_entity_id;
1194:
1195: l_job_attr get_job_attr%ROWTYPE;

Line 1562: FROM wip_entities

1558: p_wip_entity_id IN NUMBER
1559: ) RETURN BOOLEAN IS
1560: CURSOR get_job_name(c_wip_entity_id NUMBER) IS
1561: SELECT wip_entity_name, organization_id
1562: FROM wip_entities
1563: WHERE wip_entity_id = c_wip_entity_id;
1564: l_job_name get_job_name%ROWTYPE;
1565: CURSOR get_pending_job(c_wip_entity_name VARCHAR2, c_organization_id NUMBER) IS
1566: SELECT 'X'