DBA Data[Home] [Help]

APPS.BIM_CAMPAIGN_FACTS dependencies on AS_STATUSES_B

Line 832: ,as_statuses_b Y

828: FROM
829: ams_campaigns_all_b A
830: ,ams_source_codes C
831: ,as_sales_leads X
832: ,as_statuses_b Y
833: WHERE
834: X.status_code = Y.status_code
835: AND A.campaign_id = C.source_code_for_id
836: AND C.arc_source_code_for = 'CAMP'

Line 1339: ,as_statuses_b Y

1335: FROM
1336: ams_campaign_schedules_b A
1337: ,ams_source_codes C
1338: ,as_sales_leads X
1339: ,as_statuses_b Y
1340: WHERE
1341: A.schedule_id = C.source_code_for_id
1342: AND C.arc_source_code_for = 'CSCH'
1343: AND A.source_code = C.source_code

Line 3043: ,as_statuses_b Y

3039: FROM
3040: ams_campaigns_all_b A
3041: ,ams_source_codes C
3042: ,as_sales_leads X
3043: ,as_statuses_b Y
3044: WHERE
3045: X.status_code = Y.status_code
3046: AND A.campaign_id = C.source_code_for_id
3047: AND C.arc_source_code_for = 'CAMP'

Line 3551: ,as_statuses_b Y

3547: FROM
3548: ams_campaign_schedules_b A
3549: ,ams_source_codes C
3550: ,as_sales_leads X
3551: ,as_statuses_b Y
3552: WHERE
3553: A.schedule_id = C.source_code_for_id
3554: AND C.arc_source_code_for = 'CSCH'
3555: AND A.source_code = C.source_code