DBA Data[Home] [Help]

APPS.RCV_CORE_S dependencies on WIP_OPERATIONS

Line 1005: wip_operations wn,

1001: x_department_code
1002: from wip_entities we,
1003: bom_departments bd,
1004: wip_operation_resources wr,
1005: wip_operations wn,
1006: wip_operations wo
1007: where wo.wip_entity_id = x_wip_entity_id
1008: and wo.organization_id = x_organization_id
1009: and nvl(wo.repetitive_schedule_id, -1) =

Line 1006: wip_operations wo

1002: from wip_entities we,
1003: bom_departments bd,
1004: wip_operation_resources wr,
1005: wip_operations wn,
1006: wip_operations wo
1007: where wo.wip_entity_id = x_wip_entity_id
1008: and wo.organization_id = x_organization_id
1009: and nvl(wo.repetitive_schedule_id, -1) =
1010: nvl(x_wip_repetitive_schedule_id, -1)

Line 1051: wip_operations wn,

1047: INTO x_op_seq_num_dsp,
1048: x_department_code
1049: FROM bom_departments bd,
1050: wip_operation_resources wr,
1051: wip_operations wn,
1052: wip_operations wo
1053: WHERE wo.wip_entity_id = x_wip_entity_id
1054: AND wo.organization_id = x_organization_id
1055: AND NVL(wo.repetitive_schedule_id, -1) = NVL(x_wip_repetitive_schedule_id, -1)

Line 1052: wip_operations wo

1048: x_department_code
1049: FROM bom_departments bd,
1050: wip_operation_resources wr,
1051: wip_operations wn,
1052: wip_operations wo
1053: WHERE wo.wip_entity_id = x_wip_entity_id
1054: AND wo.organization_id = x_organization_id
1055: AND NVL(wo.repetitive_schedule_id, -1) = NVL(x_wip_repetitive_schedule_id, -1)
1056: AND wo.operation_seq_num = x_wip_operation_seq_num

Line 1078: wip_operations wn

1074: BEGIN
1075: SELECT bd.department_code department
1076: INTO x_department_code
1077: FROM bom_departments bd,
1078: wip_operations wn
1079: WHERE wn.wip_entity_id = x_wip_entity_id
1080: AND wn.organization_id = x_organization_id
1081: AND NVL(wn.repetitive_schedule_id, -1) = NVL(x_wip_repetitive_schedule_id, -1)
1082: AND bd.department_id = wn.department_id;

Line 1091: FROM wip_operations wo

1087:
1088: BEGIN
1089: SELECT wo.operation_seq_num SEQUENCE
1090: INTO x_op_seq_num_dsp
1091: FROM wip_operations wo
1092: WHERE wo.wip_entity_id = x_wip_entity_id
1093: AND wo.organization_id = x_organization_id
1094: AND NVL(wo.repetitive_schedule_id, -1) = NVL(x_wip_repetitive_schedule_id, -1)
1095: AND wo.operation_seq_num = x_wip_operation_seq_num;