APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_TRADING_PARTNER_SITES_S

Line 2653: MSC_Trading_Partner_Sites_S.NEXTVAL,

2649: CREATION_DATE,
2650: CREATED_BY)
2651: VALUES
2652: ( c_rec.PARTNER_ID,
2653: MSC_Trading_Partner_Sites_S.NEXTVAL,
2654: c_rec.PARTNER_ADDRESS,
2655: c_rec.LONGITUDE,
2656: c_rec.LATITUDE,
2657: 3,

Line 4491: MSC_Trading_Partner_Sites_S.NEXTVAL,

4487: CREATED_BY)
4488: VALUES
4489: ( c_rec.TP_Site_Code,
4490: c_rec.TP_ID,
4491: MSC_Trading_Partner_Sites_S.NEXTVAL,
4492: MSC_Trading_Partner_Sites_S.NEXTVAL,
4493: 1,
4494: MSC_CL_COLLECTION.v_instance_id,
4495: MSC_CL_COLLECTION.v_last_collection_id,

Line 4492: MSC_Trading_Partner_Sites_S.NEXTVAL,

4488: VALUES
4489: ( c_rec.TP_Site_Code,
4490: c_rec.TP_ID,
4491: MSC_Trading_Partner_Sites_S.NEXTVAL,
4492: MSC_Trading_Partner_Sites_S.NEXTVAL,
4493: 1,
4494: MSC_CL_COLLECTION.v_instance_id,
4495: MSC_CL_COLLECTION.v_last_collection_id,
4496: MSC_CL_COLLECTION.v_current_date,

Line 4700: MSC_Trading_Partner_Sites_S.NEXTVAL,

4696: ( c_rec.TP_Site_Code,
4697: c_rec.Location,
4698: c_rec.OPERATING_UNIT_NAME,
4699: c_rec.TP_ID,
4700: MSC_Trading_Partner_Sites_S.NEXTVAL,
4701: MSC_Trading_Partner_Sites_S.NEXTVAL,
4702: 2,
4703: MSC_CL_COLLECTION.v_instance_id,
4704: MSC_CL_COLLECTION.v_last_collection_id,

Line 4701: MSC_Trading_Partner_Sites_S.NEXTVAL,

4697: c_rec.Location,
4698: c_rec.OPERATING_UNIT_NAME,
4699: c_rec.TP_ID,
4700: MSC_Trading_Partner_Sites_S.NEXTVAL,
4701: MSC_Trading_Partner_Sites_S.NEXTVAL,
4702: 2,
4703: MSC_CL_COLLECTION.v_instance_id,
4704: MSC_CL_COLLECTION.v_last_collection_id,
4705: MSC_CL_COLLECTION.v_current_date,