DBA Data[Home] [Help]

APPS.MSC_SCE_LOADS_PKG dependencies on MSC_LOAD_BUCKETS_TEMP

Line 4238: MSC_LOAD_BUCKETS_TEMP mlb,

4234: ln.attribute14,
4235: ln.attribute15,
4236: ln.posting_party_name
4237: FROM msc_supdem_lines_interface ln,
4238: MSC_LOAD_BUCKETS_TEMP mlb,
4239: fnd_lookup_values flv,
4240: fnd_lookup_values flv1,
4241: msc_companies c,
4242: msc_company_sites s,

Line 4380: MSC_LOAD_BUCKETS_TEMP mlb,

4376: ln.attribute14,
4377: ln.attribute15,
4378: ln.posting_party_name
4379: FROM msc_supdem_lines_interface ln,
4380: MSC_LOAD_BUCKETS_TEMP mlb,
4381: fnd_lookup_values flv,
4382: fnd_lookup_values flv1,
4383: msc_companies c,
4384: msc_company_sites s

Line 4582: MSC_LOAD_BUCKETS_TEMP mlb,

4578: ln.attribute14,
4579: ln.attribute15,
4580: ln.posting_party_name
4581: FROM msc_supdem_lines_interface ln,
4582: MSC_LOAD_BUCKETS_TEMP mlb,
4583: fnd_lookup_values flv,
4584: fnd_lookup_values flv1,
4585: msc_companies c,
4586: msc_company_sites s,

Line 4724: MSC_LOAD_BUCKETS_TEMP mlb,

4720: ln.attribute14,
4721: ln.attribute15,
4722: ln.posting_party_name
4723: FROM msc_supdem_lines_interface ln,
4724: MSC_LOAD_BUCKETS_TEMP mlb,
4725: fnd_lookup_values flv,
4726: fnd_lookup_values flv1,
4727: msc_companies c,
4728: msc_company_sites s

Line 4926: MSC_LOAD_BUCKETS_TEMP mlb,

4922: ln.attribute14,
4923: ln.attribute15,
4924: ln.posting_party_name
4925: FROM msc_supdem_lines_interface ln,
4926: MSC_LOAD_BUCKETS_TEMP mlb,
4927: fnd_lookup_values flv,
4928: fnd_lookup_values flv1,
4929: msc_companies c,
4930: msc_company_sites s,

Line 5067: MSC_LOAD_BUCKETS_TEMP mlb,

5063: ln.attribute14,
5064: ln.attribute15,
5065: ln.posting_party_name
5066: FROM msc_supdem_lines_interface ln,
5067: MSC_LOAD_BUCKETS_TEMP mlb,
5068: fnd_lookup_values flv,
5069: fnd_lookup_values flv1,
5070: msc_companies c,
5071: msc_company_sites s

Line 6344: insert into MSC_LOAD_BUCKETS_TEMP

6340: lv_new_date := t_key_date_lst(i) + lv_bucket_index;
6341:
6342: EXIT WHEN lv_new_date > t_ket_end_date_lst(i);
6343:
6344: insert into MSC_LOAD_BUCKETS_TEMP
6345: (PARENT_HEADER_ID,
6346: LINE_ID,
6347: BUCKET_DATE,
6348: BUCKET_TYPE)

Line 6603: insert into MSC_LOAD_BUCKETS_TEMP

6599: lv_new_date := t_key_date_lst(i) + (7 * lv_bucket_index);
6600:
6601: EXIT WHEN lv_new_date > t_ket_end_date_lst(i);
6602:
6603: insert into MSC_LOAD_BUCKETS_TEMP
6604: (PARENT_HEADER_ID,
6605: LINE_ID,
6606: BUCKET_DATE,
6607: BUCKET_TYPE)

Line 6861: insert into MSC_LOAD_BUCKETS_TEMP

6857: lv_new_date := to_char(add_months(to_date(t_key_date_lst(i),'J') , lv_bucket_index) ,'J') ;
6858:
6859: EXIT WHEN lv_new_date > t_ket_end_date_lst(i);
6860:
6861: insert into MSC_LOAD_BUCKETS_TEMP
6862: (PARENT_HEADER_ID,
6863: LINE_ID,
6864: BUCKET_DATE,
6865: BUCKET_TYPE)