APPS.FLM_EXECUTION_UTIL dependencies on FLM_EXE_REQ_OPERATIONS

Line 1277: from flm_exe_req_operations fero

1273:
1274: CURSOR recorded_ops(p_org_id NUMBER,
1275: p_wip_ent_id NUMBER) IS
1276: select distinct operation_seq_num
1277: from flm_exe_req_operations fero
1278: where fero.organization_id = p_org_id
1279: and fero.wip_entity_id = p_wip_ent_id;
1280:
1281: BEGIN

Line 1451: from flm_exe_req_operations

1447: select 1 as subs
1448: from dual
1449: where exists (
1450: select inventory_item_id
1451: from flm_exe_req_operations
1452: where organization_id = p_org_id
1453: and wip_entity_id = p_wip_ent_id
1454: and inventory_item_id <> -1);
1455:

Line 1482: from flm_exe_req_operations fero,

1478: msi.restrict_locators_code,
1479: msi.description,
1480: msi.revision_qty_control_code,
1481: msi.location_control_code
1482: from flm_exe_req_operations fero,
1483: mtl_system_items msi
1484: where fero.organization_id = p_org_id
1485: and fero.wip_entity_id = p_wip_ent_id
1486: and fero.inventory_item_id = msi.inventory_item_id

Line 1838: from flm_exe_req_operations

1834: and wip_entity_id = p_wipEntId;
1835:
1836: CURSOR recordedDetails(p_orgId Number, p_wipEntId Number) IS
1837: select count(wip_entity_id) count
1838: from flm_exe_req_operations
1839: where organization_id = p_orgId
1840: and wip_entity_id = p_wipEntId;
1841: l_count NUMBER := 0;
1842: BEGIN

Line 1901: from flm_exe_req_operations

1897:
1898: CURSOR op_items(p_org_id IN NUMBER, p_wip_entity_id NUMBER,
1899: p_operation_seq_num NUMBER) IS
1900: select organization_id, wip_entity_id, operation_seq_num, inventory_item_id
1901: from flm_exe_req_operations
1902: where organization_id = p_org_id
1903: and wip_entity_id = p_wip_entity_id
1904: and operation_seq_num = p_operation_seq_num;
1905: