APPS.WIP_FLOW_VALIDATION dependencies on WIP_FLOW_SCHEDULES

Line 998: the other into wip_flow_schedules, we don't have

994: begin
995:
996: /**************************************************
997: As we are inserting the flow schedules one after
998: the other into wip_flow_schedules, we don't have
999: to check for duplicate schedule_number in MTI
1000: itself as this will error out by itself
1001: ***************************************************/
1002:

Line 1033: the other into wip_flow_schedules, we don't have

1029: begin
1030:
1031: /**************************************************
1032: As we are inserting the flow schedules one after
1033: the other into wip_flow_schedules, we don't have
1034: to check for duplicate schedule_number in MTI
1035: itself as this will error out by itself
1036: ***************************************************/
1037:

Line 1088: * the unit number in wip_flow_schedules.

1084: * enabled for model unit effectivity
1085: * AND the assembly is a unit effective item
1086: * AND that the unit number exists in the master org of the current organization
1087: * AND in the case of scheduled flow schedules the unit number provided matches
1088: * the unit number in wip_flow_schedules.
1089: ******************************************************************************/
1090:
1091: function unit_number(p_rowid in rowid) return number is
1092: x_success number := 0;

Line 1111: FROM wip_flow_schedules wfs

1107: WHERE P.organization_id = mti.organization_id and
1108: P.master_organization_id = N.master_organization_id)
1109: AND (mti.scheduled_flag <> 1
1110: OR exists (SELECT 1
1111: FROM wip_flow_schedules wfs
1112: WHERE wfs.wip_entity_id = mti.transaction_source_id
1113: AND wfs.end_item_unit_number = mti.end_item_unit_number
1114: )))));
1115: