APPS.WMS_STRATEGY_UPGRADE_PVT dependencies on WMS_STRATEGY_ASSIGNMENTS

Line 51: from wms_strategy_assignments wsa,

47: ,wsa.date_type_code
48: ,wsa.date_type_lookup_type
49: ,wsa.date_type_from
50: ,wsa.date_type_to
51: from wms_strategy_assignments wsa,
52: wms_org_hierarchy_objs woho
53: where wsa.organization_id = woho.organization_id
54: and wsa.object_id = woho.object_id
55: and wsa.strategy_type_code = woho.type_code

Line 76: ( organization_id wms_strategy_assignments.organization_id%type

72:
73:
74:
75: TYPE l_rec is RECORD
76: ( organization_id wms_strategy_assignments.organization_id%type
77: ,object_type_code wms_strategy_assignments.object_type_code%type
78: ,object_id wms_strategy_assignments.object_id%type
79: ,strategy_type_code wms_strategy_assignments.strategy_type_code%type
80: ,strategy_id wms_strategy_assignments.strategy_id%type

Line 77: ,object_type_code wms_strategy_assignments.object_type_code%type

73:
74:
75: TYPE l_rec is RECORD
76: ( organization_id wms_strategy_assignments.organization_id%type
77: ,object_type_code wms_strategy_assignments.object_type_code%type
78: ,object_id wms_strategy_assignments.object_id%type
79: ,strategy_type_code wms_strategy_assignments.strategy_type_code%type
80: ,strategy_id wms_strategy_assignments.strategy_id%type
81: ,pk1_value wms_strategy_assignments.pk1_value%type

Line 78: ,object_id wms_strategy_assignments.object_id%type

74:
75: TYPE l_rec is RECORD
76: ( organization_id wms_strategy_assignments.organization_id%type
77: ,object_type_code wms_strategy_assignments.object_type_code%type
78: ,object_id wms_strategy_assignments.object_id%type
79: ,strategy_type_code wms_strategy_assignments.strategy_type_code%type
80: ,strategy_id wms_strategy_assignments.strategy_id%type
81: ,pk1_value wms_strategy_assignments.pk1_value%type
82: ,pk2_value wms_strategy_assignments.pk2_value%type

Line 79: ,strategy_type_code wms_strategy_assignments.strategy_type_code%type

75: TYPE l_rec is RECORD
76: ( organization_id wms_strategy_assignments.organization_id%type
77: ,object_type_code wms_strategy_assignments.object_type_code%type
78: ,object_id wms_strategy_assignments.object_id%type
79: ,strategy_type_code wms_strategy_assignments.strategy_type_code%type
80: ,strategy_id wms_strategy_assignments.strategy_id%type
81: ,pk1_value wms_strategy_assignments.pk1_value%type
82: ,pk2_value wms_strategy_assignments.pk2_value%type
83: ,pk3_value wms_strategy_assignments.pk3_value%type

Line 80: ,strategy_id wms_strategy_assignments.strategy_id%type

76: ( organization_id wms_strategy_assignments.organization_id%type
77: ,object_type_code wms_strategy_assignments.object_type_code%type
78: ,object_id wms_strategy_assignments.object_id%type
79: ,strategy_type_code wms_strategy_assignments.strategy_type_code%type
80: ,strategy_id wms_strategy_assignments.strategy_id%type
81: ,pk1_value wms_strategy_assignments.pk1_value%type
82: ,pk2_value wms_strategy_assignments.pk2_value%type
83: ,pk3_value wms_strategy_assignments.pk3_value%type
84: ,pk4_value wms_strategy_assignments.pk4_value%type

Line 81: ,pk1_value wms_strategy_assignments.pk1_value%type

77: ,object_type_code wms_strategy_assignments.object_type_code%type
78: ,object_id wms_strategy_assignments.object_id%type
79: ,strategy_type_code wms_strategy_assignments.strategy_type_code%type
80: ,strategy_id wms_strategy_assignments.strategy_id%type
81: ,pk1_value wms_strategy_assignments.pk1_value%type
82: ,pk2_value wms_strategy_assignments.pk2_value%type
83: ,pk3_value wms_strategy_assignments.pk3_value%type
84: ,pk4_value wms_strategy_assignments.pk4_value%type
85: ,pk5_value wms_strategy_assignments.pk5_value%type

Line 82: ,pk2_value wms_strategy_assignments.pk2_value%type

78: ,object_id wms_strategy_assignments.object_id%type
79: ,strategy_type_code wms_strategy_assignments.strategy_type_code%type
80: ,strategy_id wms_strategy_assignments.strategy_id%type
81: ,pk1_value wms_strategy_assignments.pk1_value%type
82: ,pk2_value wms_strategy_assignments.pk2_value%type
83: ,pk3_value wms_strategy_assignments.pk3_value%type
84: ,pk4_value wms_strategy_assignments.pk4_value%type
85: ,pk5_value wms_strategy_assignments.pk5_value%type
86: ,effective_from wms_strategy_assignments.effective_from%type

Line 83: ,pk3_value wms_strategy_assignments.pk3_value%type

79: ,strategy_type_code wms_strategy_assignments.strategy_type_code%type
80: ,strategy_id wms_strategy_assignments.strategy_id%type
81: ,pk1_value wms_strategy_assignments.pk1_value%type
82: ,pk2_value wms_strategy_assignments.pk2_value%type
83: ,pk3_value wms_strategy_assignments.pk3_value%type
84: ,pk4_value wms_strategy_assignments.pk4_value%type
85: ,pk5_value wms_strategy_assignments.pk5_value%type
86: ,effective_from wms_strategy_assignments.effective_from%type
87: ,effective_to wms_strategy_assignments.effective_to%type

Line 84: ,pk4_value wms_strategy_assignments.pk4_value%type

80: ,strategy_id wms_strategy_assignments.strategy_id%type
81: ,pk1_value wms_strategy_assignments.pk1_value%type
82: ,pk2_value wms_strategy_assignments.pk2_value%type
83: ,pk3_value wms_strategy_assignments.pk3_value%type
84: ,pk4_value wms_strategy_assignments.pk4_value%type
85: ,pk5_value wms_strategy_assignments.pk5_value%type
86: ,effective_from wms_strategy_assignments.effective_from%type
87: ,effective_to wms_strategy_assignments.effective_to%type
88: ,date_type_code wms_strategy_assignments.date_type_code%type

Line 85: ,pk5_value wms_strategy_assignments.pk5_value%type

81: ,pk1_value wms_strategy_assignments.pk1_value%type
82: ,pk2_value wms_strategy_assignments.pk2_value%type
83: ,pk3_value wms_strategy_assignments.pk3_value%type
84: ,pk4_value wms_strategy_assignments.pk4_value%type
85: ,pk5_value wms_strategy_assignments.pk5_value%type
86: ,effective_from wms_strategy_assignments.effective_from%type
87: ,effective_to wms_strategy_assignments.effective_to%type
88: ,date_type_code wms_strategy_assignments.date_type_code%type
89: ,date_type_lookup_type wms_strategy_assignments.date_type_lookup_type%type

Line 86: ,effective_from wms_strategy_assignments.effective_from%type

82: ,pk2_value wms_strategy_assignments.pk2_value%type
83: ,pk3_value wms_strategy_assignments.pk3_value%type
84: ,pk4_value wms_strategy_assignments.pk4_value%type
85: ,pk5_value wms_strategy_assignments.pk5_value%type
86: ,effective_from wms_strategy_assignments.effective_from%type
87: ,effective_to wms_strategy_assignments.effective_to%type
88: ,date_type_code wms_strategy_assignments.date_type_code%type
89: ,date_type_lookup_type wms_strategy_assignments.date_type_lookup_type%type
90: ,date_type_from wms_strategy_assignments.date_type_from%type

Line 87: ,effective_to wms_strategy_assignments.effective_to%type

83: ,pk3_value wms_strategy_assignments.pk3_value%type
84: ,pk4_value wms_strategy_assignments.pk4_value%type
85: ,pk5_value wms_strategy_assignments.pk5_value%type
86: ,effective_from wms_strategy_assignments.effective_from%type
87: ,effective_to wms_strategy_assignments.effective_to%type
88: ,date_type_code wms_strategy_assignments.date_type_code%type
89: ,date_type_lookup_type wms_strategy_assignments.date_type_lookup_type%type
90: ,date_type_from wms_strategy_assignments.date_type_from%type
91: ,date_type_to wms_strategy_assignments.date_type_to%type

Line 88: ,date_type_code wms_strategy_assignments.date_type_code%type

84: ,pk4_value wms_strategy_assignments.pk4_value%type
85: ,pk5_value wms_strategy_assignments.pk5_value%type
86: ,effective_from wms_strategy_assignments.effective_from%type
87: ,effective_to wms_strategy_assignments.effective_to%type
88: ,date_type_code wms_strategy_assignments.date_type_code%type
89: ,date_type_lookup_type wms_strategy_assignments.date_type_lookup_type%type
90: ,date_type_from wms_strategy_assignments.date_type_from%type
91: ,date_type_to wms_strategy_assignments.date_type_to%type
92: );

Line 89: ,date_type_lookup_type wms_strategy_assignments.date_type_lookup_type%type

85: ,pk5_value wms_strategy_assignments.pk5_value%type
86: ,effective_from wms_strategy_assignments.effective_from%type
87: ,effective_to wms_strategy_assignments.effective_to%type
88: ,date_type_code wms_strategy_assignments.date_type_code%type
89: ,date_type_lookup_type wms_strategy_assignments.date_type_lookup_type%type
90: ,date_type_from wms_strategy_assignments.date_type_from%type
91: ,date_type_to wms_strategy_assignments.date_type_to%type
92: );
93:

Line 90: ,date_type_from wms_strategy_assignments.date_type_from%type

86: ,effective_from wms_strategy_assignments.effective_from%type
87: ,effective_to wms_strategy_assignments.effective_to%type
88: ,date_type_code wms_strategy_assignments.date_type_code%type
89: ,date_type_lookup_type wms_strategy_assignments.date_type_lookup_type%type
90: ,date_type_from wms_strategy_assignments.date_type_from%type
91: ,date_type_to wms_strategy_assignments.date_type_to%type
92: );
93:
94: l_stg_rec l_rec;

Line 91: ,date_type_to wms_strategy_assignments.date_type_to%type

87: ,effective_to wms_strategy_assignments.effective_to%type
88: ,date_type_code wms_strategy_assignments.date_type_code%type
89: ,date_type_lookup_type wms_strategy_assignments.date_type_lookup_type%type
90: ,date_type_from wms_strategy_assignments.date_type_from%type
91: ,date_type_to wms_strategy_assignments.date_type_to%type
92: );
93:
94: l_stg_rec l_rec;
95:

Line 161: --- Process each record, if data found in the source table "wms_strategy_assignments"

157:
158: open c_stg;
159: fetch c_stg into l_stg_rec;
160:
161: --- Process each record, if data found in the source table "wms_strategy_assignments"
162: --- and no data found in the target table "wms_selection_criteria_txn"
163:
164: WHILE ( c_stg%found and l_no_recs = 0) LOOP
165: