APPS.WIP_REQUIREMENT_DEFAULT dependencies on WIP_JOB_DETAILS

Line 104: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

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
105: AND substitution_type = p_substitution_type
106: AND operation_seq_num = p_operation_seq_num
107: AND inventory_item_id_new = p_inventory_item_id_new;
108:

Line 180: SET quantity_issued = Decode(p_substitution_type,WIP_JOB_DETAILS.WIP_ADD,0,quantity_issued),

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),
184: date_required = nvl(date_required,x_date_required),

Line 207: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT

203: required quantity and qpa */
204: WHERE group_id = p_group_id
205: AND wip_entity_id = p_wip_entity_id
206: AND organization_id = p_organization_id
207: AND load_type = WIP_JOB_DETAILS.WIP_MTL_REQUIREMENT
208: AND substitution_type = p_substitution_type
209: AND operation_seq_num = p_operation_seq_num
210: AND inventory_item_id_new = p_inventory_item_id_new;
211: