APPS.MSD_COLLECT_FACT_DATA SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 176

x_delete_flag   varchar2(1) := 'Y' ;

Line: 198

	-	   to identify whether we need to insert the
	-	   data into the staging tables or the
	-	   fact tables.
	-	3. Check for the Data Duplication, we should
	-	   use the shipped_date for this fact data.
	-	4. Insert the Data accordingly into the
	-	   Staging or the Fact table based on the
	-	   MSD_SR_SHIPMENT_DATA_V.
	-	5. Commit
	****************************************************/

	retcode :=0;

Line: 279

                        p_delete_flag       => x_delete_flag,
                        p_collect_ISO       => p_collect_ISO,             /* Bug# 4615390 ISO */
                        p_order_type_flag   => l_order_type_flag,         /* Bug# 4747555*/
                        p_order_type_ids    => l_order_type_ids);

Line: 295

                x_delete_flag   := 'N' ;

Line: 307

                        p_delete_flag       => x_delete_flag,
                        p_collect_ISO       => p_collect_ISO);    /* Bug# 4615390 ISO */

Line: 375

x_delete_flag   varchar2(1) := 'Y' ;

Line: 397

	-	   to identify whether we need to insert the
	-	   data into the staging tables or the
	-	   fact tables.
	-	3. Check for the Data Duplication, we should
	-	   use the shipped_date for this fact data.
	-	4. Insert the Data accordingly into the
	-	   Staging or the Fact table based on the
	-	   MSD_SR_BOOKING_DATA_V.
	-	5. Commit
	****************************************************/

	retcode :=0;

Line: 477

                        p_delete_flag       => x_delete_flag,
                        p_collect_ISO       => p_collect_ISO,              /* Bug# 4615390 ISO */
                        p_order_type_flag   => l_order_type_flag,          /* Bug# 4747555*/
                        p_order_type_ids    => l_order_type_ids);

Line: 493

                   x_delete_flag   := 'N' ;

Line: 505

                        p_delete_flag       => x_delete_flag,
                        p_collect_ISO       => p_collect_ISO) ;    /* Bug# 4615390 ISO */

Line: 570

        -          to identify whether we need to insert the
        -          data into the staging tables or the
        -          fact tables.
        -       3. Do a complete refresh for this instance,
        -	   hence delete all the underlying values.
        -       4. Insert the Data accordingly into the
        -          Staging or the Fact table based on the
        -          MSD_SR_UOM_CONVERSION_V
        -       5. Commit
        ****************************************************/

	retcode :=0;

Line: 674

        -          to identify whether we need to insert the
        -          data into the staging tables or the
        -          fact tables.
        -       3. Do a complete refresh for this instance,
        -          hence delete all the underlying values.
        -       4. Insert the Data accordingly into the
        -          Staging or the Fact table based on the
        -          MSD_SR_CURRENCY_CONVERSION_V
        -       5. Commit
        ****************************************************/

	retcode :=0;

Line: 775

x_delete_flag   varchar2(1) := 'Y' ;

Line: 795

        -          to identify whether we need to insert the
        -          data into the staging tables or the
        -          fact tables.
        -       3. Check for the Data Duplication, we should
        -          use the forecast_designator for this fact.
        -       4. Insert the Data accordingly into the
        -          Staging or the Fact table based on the
        -          MSD_SR_MFG_FCST_V
        -       5. Commit
        ****************************************************/

       retcode :=0;

Line: 857

                        p_delete_flag       => x_delete_flag );

Line: 869

            x_delete_flag   := 'N' ;

Line: 880

                        p_delete_flag       => x_delete_flag );

Line: 942

        -          to identify whether we need to insert the
        -          data into the staging tables or the
        -          fact tables.
        -       3. Check for the Data Duplication, we should
        -          use the shipped_date for this fact data.
        -       4. Insert the Data accordingly into the
        -          Staging or the Fact table based on the
        -          MSD_SR_PRICE_LIST_V.
        -       5. Commit
        ****************************************************/

        retcode :=0;

Line: 1073

  ret := 'delete from ' || p_table;

Line: 1124

   l_sql_stmt := 'SELECT ' ||
                    'B.TRANSACTION_TYPE_ID ORDER_TYPE_ID, ' ||
                    'UPPER(B.ORDER_CATEGORY_CODE) ORDER_CATEGORY_CODE, ' ||
                    'UPPER(T.NAME) NAME ' ||
                 'FROM ' ||
                    'OE_TRANSACTION_TYPES_TL' || p_dblink || ' T, ' ||
                    'OE_TRANSACTION_TYPES_ALL' || p_dblink || ' B '||
                 'WHERE ' ||
                    'B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID AND ' ||
                    'B.Transaction_type_code = ''ORDER'' AND ' ||
                    'nvl(B.SALES_DOCUMENT_TYPE_CODE,''O'') <> ''B'' AND ' ||
                    'T.LANGUAGE = userenv(''LANG'') ';