APPS.FLM_EXECUTION_UTIL dependencies on FLM_EXE_REQ_OPERATIONS

Line 1057: from flm_exe_req_operations fero

1053:
1054: CURSOR recorded_ops(p_org_id NUMBER,
1055: p_wip_ent_id NUMBER) IS
1056: select distinct operation_seq_num
1057: from flm_exe_req_operations fero
1058: where fero.organization_id = p_org_id
1059: and fero.wip_entity_id = p_wip_ent_id;
1060:
1061: BEGIN

Line 1231: from flm_exe_req_operations

1227: select 1 as subs
1228: from dual
1229: where exists (
1230: select inventory_item_id
1231: from flm_exe_req_operations
1232: where organization_id = p_org_id
1233: and wip_entity_id = p_wip_ent_id
1234: and inventory_item_id <> -1);
1235:

Line 1262: from flm_exe_req_operations fero,

1258: msi.restrict_locators_code,
1259: msi.description,
1260: msi.revision_qty_control_code,
1261: msi.location_control_code
1262: from flm_exe_req_operations fero,
1263: mtl_system_items msi
1264: where fero.organization_id = p_org_id
1265: and fero.wip_entity_id = p_wip_ent_id
1266: and fero.inventory_item_id = msi.inventory_item_id

Line 1618: from flm_exe_req_operations

1614: and wip_entity_id = p_wipEntId;
1615:
1616: CURSOR recordedDetails(p_orgId Number, p_wipEntId Number) IS
1617: select count(wip_entity_id) count
1618: from flm_exe_req_operations
1619: where organization_id = p_orgId
1620: and wip_entity_id = p_wipEntId;
1621: l_count NUMBER := 0;
1622: BEGIN

Line 1681: from flm_exe_req_operations

1677:
1678: CURSOR op_items(p_org_id IN NUMBER, p_wip_entity_id NUMBER,
1679: p_operation_seq_num NUMBER) IS
1680: select organization_id, wip_entity_id, operation_seq_num, inventory_item_id
1681: from flm_exe_req_operations
1682: where organization_id = p_org_id
1683: and wip_entity_id = p_wip_entity_id
1684: and operation_seq_num = p_operation_seq_num;
1685: