APPS.BIM_I_LEAD_FACTS_PKG dependencies on HZ_CODE_ASSIGNMENTS

Line 464: = (select b.class_code from hz_code_assignments b

460: --update to get customer category
461:
462: /*update bim.bim_i_lead_facts_stg stg
463: set stg.cust_category
464: = (select b.class_code from hz_code_assignments b
465: where
466: stg.customer_id=b.OWNER_TABLE_ID
467: and b.OWNER_TABLE_NAME='HZ_PARTIES'
468: and b.Primary_flag = 'Y'

Line 474: (select b.class_code from hz_code_assignments b

470: and b.CLASS_CATEGORY='CUSTOMER_CATEGORY'
471: and b.status='A')
472: where
473: exists
474: (select b.class_code from hz_code_assignments b
475: where
476: stg.customer_id=b.OWNER_TABLE_ID
477: and b.OWNER_TABLE_NAME='HZ_PARTIES'
478: and b.Primary_flag = 'Y'

Line 486: = (select b.class_code from hz_code_assignments b

482: */
483:
484: update bim_i_lead_facts_stg stg
485: set stg.cust_category
486: = (select b.class_code from hz_code_assignments b
487: where
488: stg.customer_id=b.OWNER_TABLE_ID
489: and b.OWNER_TABLE_NAME='HZ_PARTIES'
490: and b.Primary_flag = 'Y'

Line 495: ( select max(START_DATE_ACTIVE) from hz_code_assignments c

491: and nvl(b.end_date_active,trunc(l_sysdate)) > = trunc(l_sysdate)
492: and b.CLASS_CATEGORY='CUSTOMER_CATEGORY'
493: and b.status='A'--Active
494: and b.START_DATE_ACTIVE =
495: ( select max(START_DATE_ACTIVE) from hz_code_assignments c
496: where
497: c.OWNER_TABLE_NAME='HZ_PARTIES'
498: and c.CLASS_CATEGORY='CUSTOMER_CATEGORY'
499: and c.Primary_flag = 'Y'

Line 506: (select b.class_code from hz_code_assignments b

502: and b.OWNER_TABLE_ID=c.OWNER_TABLE_ID)
503: )
504: where
505: exists
506: (select b.class_code from hz_code_assignments b
507: where
508: stg.customer_id=b.OWNER_TABLE_ID
509: and b.OWNER_TABLE_NAME='HZ_PARTIES'
510: and b.Primary_flag = 'Y'

Line 515: ( select max(START_DATE_ACTIVE) from hz_code_assignments c

511: and nvl(b.end_date_active,trunc(l_sysdate)) > = trunc(l_sysdate)
512: and b.CLASS_CATEGORY='CUSTOMER_CATEGORY'
513: and b.status='A'--Active
514: and b.START_DATE_ACTIVE =
515: ( select max(START_DATE_ACTIVE) from hz_code_assignments c
516: where
517: c.OWNER_TABLE_NAME='HZ_PARTIES'
518: and c.CLASS_CATEGORY='CUSTOMER_CATEGORY'
519: and c.Primary_flag = 'Y'

Line 1084: = (select b.class_code from hz_code_assignments b

1080: --update to get customer category
1081:
1082: update bim_i_lead_facts_stg stg
1083: set stg.cust_category
1084: = (select b.class_code from hz_code_assignments b
1085: where
1086: stg.customer_id=b.OWNER_TABLE_ID
1087: and b.OWNER_TABLE_NAME='HZ_PARTIES'
1088: and b.Primary_flag = 'Y'

Line 1093: ( select max(START_DATE_ACTIVE) from hz_code_assignments c

1089: and nvl(b.end_date_active,trunc(l_sysdate)) > = trunc(l_sysdate)
1090: and b.CLASS_CATEGORY='CUSTOMER_CATEGORY'
1091: and b.status='A'--Active
1092: and b.START_DATE_ACTIVE =
1093: ( select max(START_DATE_ACTIVE) from hz_code_assignments c
1094: where
1095: c.OWNER_TABLE_NAME='HZ_PARTIES'
1096: and c.CLASS_CATEGORY='CUSTOMER_CATEGORY'
1097: and c.Primary_flag = 'Y'

Line 1104: (select b.class_code from hz_code_assignments b

1100: and b.OWNER_TABLE_ID=c.OWNER_TABLE_ID)
1101: )
1102: where
1103: exists
1104: (select b.class_code from hz_code_assignments b
1105: where
1106: stg.customer_id=b.OWNER_TABLE_ID
1107: and b.OWNER_TABLE_NAME='HZ_PARTIES'
1108: and b.Primary_flag = 'Y'

Line 1113: ( select max(START_DATE_ACTIVE) from hz_code_assignments c

1109: and nvl(b.end_date_active,trunc(l_sysdate)) > = trunc(l_sysdate)
1110: and b.CLASS_CATEGORY='CUSTOMER_CATEGORY'
1111: and b.status='A'--Active
1112: and b.START_DATE_ACTIVE =
1113: ( select max(START_DATE_ACTIVE) from hz_code_assignments c
1114: where
1115: c.OWNER_TABLE_NAME='HZ_PARTIES'
1116: and c.CLASS_CATEGORY='CUSTOMER_CATEGORY'
1117: and c.Primary_flag = 'Y'