APPS.MSC_CL_SETUP_ODS_LOAD dependencies on MSC_TRADING_PARTNER_SITES_S

Line 2643: MSC_Trading_Partner_Sites_S.NEXTVAL,

2639: CREATION_DATE,
2640: CREATED_BY)
2641: VALUES
2642: ( c_rec.PARTNER_ID,
2643: MSC_Trading_Partner_Sites_S.NEXTVAL,
2644: c_rec.PARTNER_ADDRESS,
2645: c_rec.LONGITUDE,
2646: c_rec.LATITUDE,
2647: 3,

Line 4481: MSC_Trading_Partner_Sites_S.NEXTVAL,

4477: CREATED_BY)
4478: VALUES
4479: ( c_rec.TP_Site_Code,
4480: c_rec.TP_ID,
4481: MSC_Trading_Partner_Sites_S.NEXTVAL,
4482: MSC_Trading_Partner_Sites_S.NEXTVAL,
4483: 1,
4484: MSC_CL_COLLECTION.v_instance_id,
4485: MSC_CL_COLLECTION.v_last_collection_id,

Line 4482: MSC_Trading_Partner_Sites_S.NEXTVAL,

4478: VALUES
4479: ( c_rec.TP_Site_Code,
4480: c_rec.TP_ID,
4481: MSC_Trading_Partner_Sites_S.NEXTVAL,
4482: MSC_Trading_Partner_Sites_S.NEXTVAL,
4483: 1,
4484: MSC_CL_COLLECTION.v_instance_id,
4485: MSC_CL_COLLECTION.v_last_collection_id,
4486: MSC_CL_COLLECTION.v_current_date,

Line 4690: MSC_Trading_Partner_Sites_S.NEXTVAL,

4686: ( c_rec.TP_Site_Code,
4687: c_rec.Location,
4688: c_rec.OPERATING_UNIT_NAME,
4689: c_rec.TP_ID,
4690: MSC_Trading_Partner_Sites_S.NEXTVAL,
4691: MSC_Trading_Partner_Sites_S.NEXTVAL,
4692: 2,
4693: MSC_CL_COLLECTION.v_instance_id,
4694: MSC_CL_COLLECTION.v_last_collection_id,

Line 4691: MSC_Trading_Partner_Sites_S.NEXTVAL,

4687: c_rec.Location,
4688: c_rec.OPERATING_UNIT_NAME,
4689: c_rec.TP_ID,
4690: MSC_Trading_Partner_Sites_S.NEXTVAL,
4691: MSC_Trading_Partner_Sites_S.NEXTVAL,
4692: 2,
4693: MSC_CL_COLLECTION.v_instance_id,
4694: MSC_CL_COLLECTION.v_last_collection_id,
4695: MSC_CL_COLLECTION.v_current_date,