eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_REQUIREMENT_VALIDATIONS dependencies on WIP_REQUIREMENT_OPERATIONS

Line 93: from wip_requirement_operations wro

89: and wjdi.wip_entity_id = we.wip_entity_id
90: and wjdi.inventory_item_id_old = msik.inventory_item_id
91: and wjdi.organization_id = msik.organization_id
92: and not exists (select 1
93: from wip_requirement_operations wro
94: where wro.wip_entity_id = wjdi.wip_entity_id
95: and wro.organization_id = wjdi.organization_id
96: and wro.operation_seq_num = wjdi.operation_seq_num
97: and wro.inventory_item_id = wjdi.inventory_item_id_old);

Line 137: from wip_requirement_operations wro

133: and wjdi.substitution_type = p_substitution_type
134: and wjdi.operation_seq_num = p_operation_seq_num
135: and wjdi.inventory_item_id_old = p_inventory_item_id_old
136: and not exists (select 1
137: from wip_requirement_operations wro
138: where wro.wip_entity_id = wjdi.wip_entity_id
139: and wro.organization_id = wjdi.organization_id
140: and wro.operation_seq_num = wjdi.operation_seq_num
141: and wro.inventory_item_id = wjdi.inventory_item_id_old);

Line 170: from wip_requirement_operations wro

166: and wjdi.substitution_type = p_substitution_type
167: and wjdi.operation_seq_num = p_operation_seq_num
168: and wjdi.inventory_item_id_old = p_inventory_item_id_old
169: and exists (select 1
170: from wip_requirement_operations wro
171: where wro.wip_entity_id = p_wip_entity_id
172: and wro.organization_id = p_organization_id
173: and wro.operation_seq_num = p_operation_seq_num
174: and wro.inventory_item_id = p_inventory_item_id_old

Line 249: from wip_requirement_operations wro

245: and wjdi.substitution_type = p_substitution_type
246: and wjdi.operation_seq_num = p_operation_seq_num
247: and wjdi.inventory_item_id_old = p_inventory_item_id_old
248: and exists (select 1
249: from wip_requirement_operations wro
250: where wro.wip_entity_id = wjdi.wip_entity_id
251: and wro.organization_id = wjdi.organization_id
252: and wro.operation_seq_num = wjdi.operation_seq_num
253: and wro.inventory_item_id = wjdi.inventory_item_id_old

Line 492: from wip_requirement_operations wro

488: and wjdi.inventory_item_id_new = p_inventory_item_id_new
489: /* bug#2814045 */
490: and nvl(wjdi.inventory_item_id_new, -1) <> nvl(wjdi.inventory_item_id_old, -1)
491: and ( exists (select 1
492: from wip_requirement_operations wro
493: where wro.wip_entity_id = wjdi.wip_entity_id
494: and wro.organization_id = wjdi.organization_id
495: and wro.operation_seq_num = wjdi.operation_seq_num
496: and wro.inventory_item_id = wjdi.inventory_item_id_new)

Line 542: from wip_requirement_operations wro

538: /* Fix for Bug 5632150 */
539: /* and wjdi.inventory_item_id_new <> wjdi.inventory_item_id_old */
540: and nvl(wjdi.inventory_item_id_new,-1) <> nvl(wjdi.inventory_item_id_old,-1)
541: and ( exists (select 1
542: from wip_requirement_operations wro
543: where wro.wip_entity_id = wjdi.wip_entity_id
544: and wro.organization_id = wjdi.organization_id
545: and wro.operation_seq_num = wjdi.operation_seq_num
546: and wro.inventory_item_id = wjdi.inventory_item_id_new)

Line 899: FROM WIP_JOB_DTLS_INTERFACE wjdi,WIP_REQUIREMENT_OPERATIONS wro

895: NULL,
896: wro.supply_locator_id,
897: wjdi.supply_locator_id)) supply_locator_id
898: ,NVL(WJDI.wip_supply_Type,wro.wip_supply_type) wip_supply_type
899: FROM WIP_JOB_DTLS_INTERFACE wjdi,WIP_REQUIREMENT_OPERATIONS wro
900: WHERE group_id=p_group_id
901: AND wjdi.process_phase = WIP_CONSTANTS.ML_VALIDATION
902: AND wjdi.process_status in (WIP_CONSTANTS.RUNNING,WIP_CONSTANTS.WARNING)
903: AND wjdi.wip_entity_id = p_wip_entity_id

Line 915: supply_subinventory WIP_REQUIREMENT_OPERATIONS.supply_subinventory%TYPE,

911: l_inventory_itemid NUMBER;
912: rec changesubinv_check%ROWTYPE;
913: TYPE errorrec is RECORD ( interface_id NUMBER,
914: inventory_item_id NUMBER,
915: supply_subinventory WIP_REQUIREMENT_OPERATIONS.supply_subinventory%TYPE,
916: error_msg VARCHAR2(500));
917: TYPE error_typ IS TABLE OF errorrec INDEX BY BINARY_INTEGER;
918: error_tbl error_typ;
919: l_subinventory WIP_REQUIREMENT_OPERATIONS.supply_subinventory%TYPE;

Line 919: l_subinventory WIP_REQUIREMENT_OPERATIONS.supply_subinventory%TYPE;

915: supply_subinventory WIP_REQUIREMENT_OPERATIONS.supply_subinventory%TYPE,
916: error_msg VARCHAR2(500));
917: TYPE error_typ IS TABLE OF errorrec INDEX BY BINARY_INTEGER;
918: error_tbl error_typ;
919: l_subinventory WIP_REQUIREMENT_OPERATIONS.supply_subinventory%TYPE;
920: l_wipsupply NUMBER;
921: l_locatorid NUMBER;
922: l_inventoryitem NUMBER;
923: l_interfaceid NUMBER;

Line 1292: from wip_requirement_operations wro

1288: from bom_substitute_components bsc
1289: where bsc.substitute_component_id = wjdi.inventory_item_id_new
1290: and bsc.component_sequence_id =
1291: (select wro.component_sequence_id
1292: from wip_requirement_operations wro
1293: where wro.inventory_item_id = wjdi.inventory_item_id_old
1294: and wro.wip_entity_id = wjdi.wip_entity_id
1295: and wro.operation_seq_num = wjdi.operation_seq_num
1296: and wro.organization_id = wjdi.organization_id

Line 1392: FROM wip_requirement_operations

1388: /*Component Yield Enhancement(Bug 4369064)->Get the current values of qpa, req_qty and yield*/
1389: begin
1390: SELECT nvl(component_yield_factor,1),required_quantity,quantity_per_assembly
1391: INTO x_component_yield_factor_wro,x_required_quantity_wro,x_quantity_per_assembly_wro
1392: FROM wip_requirement_operations
1393: WHERE wip_entity_id = p_wip_entity_id
1394: AND organization_id = p_organization_id
1395: AND inventory_item_id = p_inventory_item_id_old;
1396: exception