DBA Data[Home] [Help]

APPS.WIP_OVERCOMPLETION dependencies on STANDARD

Line 982: from bom_standard_operations bso,

978: INTO
979: x_last_operation_code,
980: x_last_department_id,
981: x_last_department_code
982: from bom_standard_operations bso,
983: bom_departments bd,
984: wip_operations wo
985: WHERE wo.operation_seq_num = x_last_operation_seq_num
986: AND wo.department_id = bd.department_id

Line 987: AND wo.standard_operation_id = bso.standard_operation_id (+)

983: bom_departments bd,
984: wip_operations wo
985: WHERE wo.operation_seq_num = x_last_operation_seq_num
986: AND wo.department_id = bd.department_id
987: AND wo.standard_operation_id = bso.standard_operation_id (+)
988: AND wo.organization_id = x_org_id
989: AND wo.wip_entity_id = x_wip_entity_id
990: AND (wo.repetitive_schedule_id is NULL
991: OR