APPS.WIP_REQUIREMENT_DEFAULT dependencies on WIP_JOB_DTLS_INTERFACE

Line 100: FROM WIP_JOB_DTLS_INTERFACE

96: if supply subinv/locator is not present at item level,
97: copy from org parameters as they are mandatory */
98: SELECT wip_supply_type
99: INTO X_temp_wip_supply_type
100: FROM WIP_JOB_DTLS_INTERFACE
101: WHERE group_id = p_group_id
102: AND wip_entity_id = p_wip_entity_id
103: AND organization_id = p_organization_id
104: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

Line 179: UPDATE WIP_JOB_DTLS_INTERFACE

175: end ;
176:
177: end if ;
178:
179: UPDATE WIP_JOB_DTLS_INTERFACE
180: SET quantity_issued = Decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,quantity_issued),
181: quantity_per_assembly = round(X_quantity_per_assembly, 6),
182: department_id = x_department_id,
183: wip_supply_type = nvl(wip_supply_type,x_wip_supply_type),