DBA Data[Home] [Help]

APPS.MSC_CL_EAM_ODS_LOAD dependencies on MSC_ST_EAM_ACT_ASSOCIATIONS

Line 15: FROM MSC_ST_EAM_ACT_ASSOCIATIONS mseaa

11: SELECT mseaa.ASSET_ACTIVITY_ID,
12: mseaa.ORGANIZATION_ID,
13: mseaa.ASSET_REBUILD_ITEM_ID,
14: mseaa.SR_INSTANCE_ID
15: FROM MSC_ST_EAM_ACT_ASSOCIATIONS mseaa
16: WHERE mseaa.deleted_flag = MSC_UTIL.SYS_YES
17: AND mseaa.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
18:
19: CURSOR c_del2 IS

Line 92: ||' FROM MSC_ST_EAM_ACT_ASSOCIATIONS mseaa,'

88: ||' mseaa.ACTIVITY_TYPE,'
89: ||' mseaa.ASSET_REBUILD_GROUP,'
90: ||' mseaa.EAM_ITEM_TYPE,'
91: ||' mseaa.SR_INSTANCE_ID'
92: ||' FROM MSC_ST_EAM_ACT_ASSOCIATIONS mseaa,'
93: ||' MSC_ITEM_ID_LID m1,'
94: ||' MSC_ITEM_ID_LID m2'
95: ||' WHERE mseaa.SR_INSTANCE_ID= '
96: ||MSC_CL_COLLECTION.v_instance_id

Line 167: ||' FROM MSC_ST_EAM_ACT_ASSOCIATIONS mseaa,'

163: ||' :v_current_date, '
164: ||' :v_current_user, '
165: ||' :v_current_date, '
166: ||' :v_current_user '
167: ||' FROM MSC_ST_EAM_ACT_ASSOCIATIONS mseaa,'
168: ||' MSC_ITEM_ID_LID m1,'
169: ||' MSC_ITEM_ID_LID m2'
170: ||' WHERE mseaa.SR_INSTANCE_ID= '
171: ||MSC_CL_COLLECTION.v_instance_id