DBA Data[Home] [Help]

APPS.WIP_OP_LINK_VALIDATIONS dependencies on WIP_OPERATION_NETWORKS

Line 68: FROM wip_operation_networks

64: x_err_code out nocopy varchar2, x_err_msg out nocopy varchar2,
65: x_return_status out nocopy varchar2) is
66: CURSOR c_link_rows IS
67: SELECT prior_operation, next_operation
68: FROM wip_operation_networks
69: WHERE wip_entity_id = p_wip_entity_id
70: AND organization_id = p_organization_id;
71:
72: l_id number;

Line 135: FROM WIP_OPERATION_NETWORKS

131: AND organization_id = p_organization_id
132: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
133: AND substitution_type = p_subst_type;
134: /* AND exists (select 1
135: FROM WIP_OPERATION_NETWORKS
136: WHERE wip_entity_id = wjdi.wip_entity_id
137: AND organization_id = wjdi.organization_id
138: AND prior_operation = wjdi.operation_seq_num
139: AND next_operation = wjdi.next_network_op_seq_num);

Line 425: FROM WIP_OPERATION_NETWORKS

421: AND organization_id = p_organization_id
422: AND load_type = WIP_JOB_DETAILS.WIP_OP_LINK
423: AND substitution_type = p_subst_type
424: AND exists (select 1
425: FROM WIP_OPERATION_NETWORKS
426: WHERE wip_entity_id = wjdi.wip_entity_id
427: AND organization_id = wjdi.organization_id
428: AND prior_operation = wjdi.operation_seq_num
429: AND next_operation = wjdi.next_network_op_seq_num);