APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_REQUIREMENT_OPERATIONS

Line 1286: DELETE FROM WIP_REQUIREMENT_OPERATIONS

1282: FOR cur_row IN req_info(p_group_id,
1283: p_wip_entity_id,
1284: p_organization_id) LOOP
1285:
1286: DELETE FROM WIP_REQUIREMENT_OPERATIONS
1287: WHERE wip_entity_id = p_wip_entity_id
1288: AND organization_id = p_organization_id
1289: AND operation_seq_num = cur_row.operation_seq_num
1290: AND inventory_item_id = cur_row.inventory_item_id_old;

Line 1359: INSERT INTO WIP_REQUIREMENT_OPERATIONS(

1355: p_organization_id) LOOP
1356:
1357: /** Fix for bug 2649338
1358: -- stripped off time part from date_required and mps_date_required **/
1359: INSERT INTO WIP_REQUIREMENT_OPERATIONS(
1360: wip_entity_id,
1361: organization_id,
1362: operation_seq_num,
1363: inventory_item_id,

Line 1515: FROM wip_requirement_operations

1511: p_organization_id) LOOP
1512:
1513: SELECT required_quantity, wip_supply_type, supply_subinventory, supply_locator_id
1514: into l_required_quantity, l_wip_supply_type, l_supply_subinventory, l_supply_locator_id
1515: FROM wip_requirement_operations
1516: WHERE wip_entity_id = p_wip_entity_id
1517: AND organization_id = p_organization_id
1518: AND operation_seq_num = cur_row.operation_seq_num
1519: AND inventory_item_id = cur_row.inventory_item_id_old;

Line 1579: UPDATE WIP_REQUIREMENT_OPERATIONS

1575: /* update table */
1576: /** Fix for bug 2438722 - correct attribute cols updated **/
1577: /** Fix for bug 2649338
1578: -- stripped off time part from date_required and mps_date_required **/
1579: UPDATE WIP_REQUIREMENT_OPERATIONS
1580: SET inventory_item_id = NVL(cur_row.inventory_item_id_new,
1581: inventory_item_id),
1582: quantity_per_assembly = NVL(round(
1583: cur_row.quantity_per_assembly,6),

Line 1818: FROM wip_requirement_operations wro

1814: SELECT 1
1815: INTO l_op_exists
1816: FROM dual
1817: WHERE EXISTS (SELECT 1
1818: FROM wip_requirement_operations wro
1819: WHERE wro.organization_id = p_organization_id
1820: AND wro.wip_entity_id = p_wip_entity_id
1821: AND (wro.operation_seq_num = 1 OR wro.operation_seq_num = -1)
1822: AND wro.quantity_issued <> 0);

Line 1861: FROM wip_requirement_operations wro

1857: SELECT 1
1858: INTO l_txn_exists
1859: FROM dual
1860: WHERE EXISTS (SELECT 1
1861: FROM wip_requirement_operations wro
1862: WHERE wro.organization_id = p_organization_id
1863: AND wro.wip_entity_id = p_wip_entity_id
1864: AND (wro.operation_seq_num = 1 OR wro.operation_seq_num = -1)
1865: AND wro.quantity_issued <> 0);

Line 2371: UPDATE WIP_REQUIREMENT_OPERATIONS WRO

2367: /*END bug 3659006 */
2368:
2369: -- Start : Fix Bug#5116297/5129311
2370: -- Update date_required for Components on this Operation
2371: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
2372: SET WRO.DATE_REQUIRED =
2373: (SELECT FIRST_UNIT_START_DATE
2374: FROM WIP_OPERATIONS
2375: WHERE WIP_ENTITY_ID = p_wip_entity_id