DBA Data[Home] [Help]

APPS.BIM_I_SRC_CODE_PKG dependencies on AMS_EVENT_HEADERS_ALL_B

Line 481: ams_event_headers_all_b b,

477: else b.active_to_date end adj_end_date,
478: b.last_update_date obj_last_update_date
479: FROM
480: ams_source_codes a,
481: ams_event_headers_all_b b,
482: jtf_loc_hierarchies_b d,
483: bis_territory_hierarchies t
484: WHERE
485: a.source_code = b.source_code

Line 535: ams_event_headers_all_b b,

531: c.event_end_date),'DD/MM/RRRR') end adj_end_date,
532: c.last_update_date obj_last_update_date
533: FROM
534: ams_source_codes a,
535: ams_event_headers_all_b b,
536: ams_event_offers_all_b c,
537: jtf_loc_hierarchies_b d,
538: jtf_loc_hierarchies_b d2,
539: bis_territory_hierarchies t ,

Line 1075: ams_event_headers_all_b b,

1071: else b.active_to_date end adj_end_date,
1072: b.last_update_date obj_last_update_date
1073: FROM
1074: ams_source_codes a,
1075: ams_event_headers_all_b b,
1076: jtf_loc_hierarchies_b d,
1077: bis_territory_hierarchies t
1078: WHERE
1079: ((b.last_update_date between p_start_date and p_end_date and b.active_from_date <= p_start_date) or (b.active_from_date between p_start_date and p_end_date))

Line 1129: ams_event_headers_all_b b,

1125: c.event_end_date),'DD/MM/RRRR') end adj_end_date,
1126: c.last_update_date obj_last_update_date
1127: FROM
1128: ams_source_codes a,
1129: ams_event_headers_all_b b,
1130: ams_event_offers_all_b c,
1131: jtf_loc_hierarchies_b d,
1132: jtf_loc_hierarchies_b d2,
1133: bis_territory_hierarchies t,