APPS.WSMPLBJI dependencies on WIP_OPERATION_RESOURCES

Line 1952: INSERT INTO WIP_OPERATION_RESOURCES

1948: end if;
1949:
1950:
1951: l_stat_num := 80;
1952: INSERT INTO WIP_OPERATION_RESOURCES
1953: (WIP_ENTITY_ID,
1954: OPERATION_SEQ_NUM,
1955: RESOURCE_SEQ_NUM,
1956: ORGANIZATION_ID,

Line 2010: from Wip_operation_resources WOR

2006: AND ORS.RESOURCE_ID = RSC.RESOURCE_ID
2007: AND RSC.ORGANIZATION_ID = OPS.ORGANIZATION_ID
2008: AND ORS.OPERATION_SEQUENCE_ID = p_seq_id
2009: AND OPS.OPERATION_SEQ_NUM NOT IN (select WOR.OPERATION_SEQ_NUM
2010: from Wip_operation_resources WOR
2011: where WOR.wip_entity_id = p_wip_entity_id);
2012:
2013: if lbji_debug = 'Y' then
2014: fnd_file.put_line(fnd_file.log, 'Inserted '||SQL%ROWCOUNT||' rows into wor');

Line 2170: FROM WIP_OPERATION_RESOURCES

2166: FROM WSM_SM_RESULTING_JOBS
2167: WHERE ORGANIZATION_ID = p_organization_id
2168: AND WIP_ENTITY_ID = p_wip_entity_id)
2169: OR EXISTS (SELECT 'X'
2170: FROM WIP_OPERATION_RESOURCES
2171: WHERE ORGANIZATION_ID = p_organization_id
2172: AND WIP_ENTITY_ID = p_wip_entity_id
2173: AND APPLIED_RESOURCE_UNITS <> 0));
2174:

Line 2220: FROM WIP_OPERATION_RESOURCES

2216: FROM WSM_SM_RESULTING_JOBS
2217: WHERE ORGANIZATION_ID = p_organization_id
2218: AND WIP_ENTITY_ID = p_wip_entity_id)
2219: OR EXISTS (SELECT 'X'
2220: FROM WIP_OPERATION_RESOURCES
2221: WHERE ORGANIZATION_ID = p_organization_id
2222: AND WIP_ENTITY_ID = p_wip_entity_id
2223: AND APPLIED_RESOURCE_UNITS <> 0));
2224: BEGIN

Line 5588: delete from wip_operation_resources where wip_entity_id = v_wlji_wip_entity_id(v_index);

5584: end if;
5585:
5586: l_stmt_num := 700.2;
5587: delete from wip_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);
5588: delete from wip_operation_resources where wip_entity_id = v_wlji_wip_entity_id(v_index);
5589: delete from wip_requirement_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);
5590: delete from wip_operation_yields where wip_entity_id = v_wlji_wip_entity_id(v_index);
5591:
5592: l_stmt_num := 700.3;

Line 6079: delete from wip_operation_resources

6075: delete from wip_operations
6076: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6077: delete from wip_operation_yields
6078: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6079: delete from wip_operation_resources
6080: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6081: delete from wip_requirement_operations
6082: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6083: exception

Line 6901: UPDATE WIP_OPERATION_RESOURCES

6897: fnd_file.put_line(fnd_file.log, 'Updated '||SQL%ROWCOUNT||' rows into wo');
6898: end if;
6899:
6900: l_stmt_num := 1063;
6901: UPDATE WIP_OPERATION_RESOURCES
6902: SET START_DATE = decode(l_txnexist,
6903: 0, NVL(v_wlji_fusd(v_index), START_DATE), -- bug 3394520
6904: START_DATE),
6905: COMPLETION_DATE = decode(l_txnexist,