APPS.BIM_I_SGMT_CUST_FACTS_PKG dependencies on BIM_I_PARTY_SGMT_STG

Line 689: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_party_sgmt_stg';

685: bis_collection_utilities.log('Inserting Segment Customer Details');
686:
687: l_return := fnd_installation.get_app_info('BIM', l_status, l_industry, l_schema);
688:
689: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_party_sgmt_stg';
690:
691: --SQL TO COLLECT PARTIES AND SEGMENT COMBINATION WHICH IS PRESENT IN FACT
692: --TABLE AND POPULATE THIS DATA IN STAGING TABLE
693:

Line 694: Execute Immediate 'INSERT /*+Append parallel*/ INTO bim_i_party_sgmt_stg ' ||

690:
691: --SQL TO COLLECT PARTIES AND SEGMENT COMBINATION WHICH IS PRESENT IN FACT
692: --TABLE AND POPULATE THIS DATA IN STAGING TABLE
693:
694: Execute Immediate 'INSERT /*+Append parallel*/ INTO bim_i_party_sgmt_stg ' ||
695: ' ( ' ||
696: ' segment_id ' ||
697: ' ,party_id ' ||
698: ' ,end_date_active ' ||

Line 762: FROM bim_i_party_sgmt_stg stg

758: --UPDATE STATEMENT FOR END_DATE_ACTIVE IF END_DATE_ACTIVE IS DIFFRENT FROM LAST RUN
759:
760: UPDATE bim_i_party_sgmt_facts facts
761: SET end_date_Active = ( SELECT TRUNC(end_date_active)
762: FROM bim_i_party_sgmt_stg stg
763: WHERE facts.segment_id=stg.segment_id
764: AND facts.party_id = stg.party_id
765: )
766: WHERE EXISTS (SELECT 1

Line 767: FROM bim_i_party_sgmt_stg stg

763: WHERE facts.segment_id=stg.segment_id
764: AND facts.party_id = stg.party_id
765: )
766: WHERE EXISTS (SELECT 1
767: FROM bim_i_party_sgmt_stg stg
768: WHERE facts.segment_id=stg.segment_id
769: AND facts.party_id = stg.party_id
770: AND facts.end_date_active<>stg.end_date_active
771: ) ;

Line 777: FROM bim_i_party_sgmt_stg stg

773: --UPDATE STATEMENT FOR ACCOUNT_CLOSURE_DATE IF ACCOUNT_CLOSURE_DATE IS DIFFRENT FROM LAST RUN
774:
775: UPDATE bim_i_party_sgmt_facts facts
776: SET account_close_date = ( SELECT TRUNC(account_close_date)
777: FROM bim_i_party_sgmt_stg stg
778: WHERE facts.segment_id=stg.segment_id
779: AND facts.party_id = stg.party_id
780: )
781: WHERE EXISTS (SELECT 1

Line 782: FROM bim_i_party_sgmt_stg stg

778: WHERE facts.segment_id=stg.segment_id
779: AND facts.party_id = stg.party_id
780: )
781: WHERE EXISTS (SELECT 1
782: FROM bim_i_party_sgmt_stg stg
783: WHERE facts.segment_id=stg.segment_id
784: AND facts.party_id = stg.party_id
785: AND facts.account_close_date <> stg.account_close_date
786: );

Line 846: ' FROM bim_i_party_sgmt_stg stg ' ||

842: ' AND OBJECT_TYPE(+)=''PERSON'' ' ||
843: ' AND nvl(reln.subject_id,a.party_id)=parties.party_id ' ||
844: ' AND trunc(a.last_update_date) BETWEEN '''||p_start_date||''' AND '''||p_end_date||''''||
845: ' AND NOT EXISTS ( SELECT 1 ' ||
846: ' FROM bim_i_party_sgmt_stg stg ' ||
847: ' WHERE stg.segment_id=a.market_segment_id ' ||
848: ' AND nvl(reln.subject_id,a.party_id)=stg.party_id ' ||
849: ' ) ' ||
850: ' GROUP BY nvl(reln.subject_id,a.party_id),a.market_segment_id,parties.status,parties.last_update_date ' ;

Line 870: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_party_sgmt_stg';

866: AND b.creation_date >= g_initial_start_date)
867: AND account_open_date IS NULL;
868:
869:
870: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_schema||'.bim_i_party_sgmt_stg';
871:
872: bis_collection_utilities.wrapup(p_status => TRUE
873: ,p_count => sql%rowcount
874: ,p_period_from => p_start_date