eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_SUB_INVENTORIES

Line 1118: ||' on MSC_ST_SUB_INVENTORIES '

1114: application_short_name => 'MSC',
1115: statement_type => AD_DDL.CREATE_INDEX,
1116: statement =>
1117: 'create index MSC_ST_SUB_INV_N1_'||v_instance_code
1118: ||' on MSC_ST_SUB_INVENTORIES '
1119: ||'( sr_instance_code, sub_inventory_code, organization_code ) '
1120: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1121: object_name =>'MSC_ST_SUB_INV_N1_'||v_instance_code);
1122:

Line 1210: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUB_INVENTORIES', v_instance_id, -1);

1206:
1207:
1208: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNERS', v_instance_id, -1);
1209: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNER_SITES', v_instance_id, -1);
1210: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUB_INVENTORIES', v_instance_id, -1);
1211: msc_analyse_tables_pk.analyse_table( 'MSC_ST_LOCATION_ASSOCIATIONS', v_instance_id, -1);
1212: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PARTNER_CONTACTS', v_instance_id, -1);
1213:
1214: END IF;

Line 6294: FROM msc_st_sub_inventories

6290: AND deleted_flag = SYS_NO;
6291:
6292: CURSOR c5(p_batch_id NUMBER) IS
6293: SELECT rowid
6294: FROM msc_st_sub_inventories
6295: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
6296: AND sr_instance_code = v_instance_code
6297: AND batch_id = p_batch_id;
6298:

Line 8419: --Validation for MSC_ST_SUB_INVENTORIES

8415: END IF ; -- v_install_msd
8416: COMMIT;
8417: END LOOP;
8418:
8419: --Validation for MSC_ST_SUB_INVENTORIES
8420:
8421:
8422: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
8423: (p_app_short_name => 'MSC',

Line 8435: 'UPDATE msc_st_sub_inventories mssi1 '

8431:
8432: -- UDK validations
8433: v_sql_stmt := 29;
8434: lv_sql_stmt :=
8435: 'UPDATE msc_st_sub_inventories mssi1 '
8436: ||' SET process_flag = '||G_ERROR_FLG||','
8437: ||' error_text = '||''''||lv_message_text||''''
8438: ||' WHERE EXISTS( SELECT 1 '
8439: ||' FROM msc_st_sub_inventories mssi2 '

Line 8439: ||' FROM msc_st_sub_inventories mssi2 '

8435: 'UPDATE msc_st_sub_inventories mssi1 '
8436: ||' SET process_flag = '||G_ERROR_FLG||','
8437: ||' error_text = '||''''||lv_message_text||''''
8438: ||' WHERE EXISTS( SELECT 1 '
8439: ||' FROM msc_st_sub_inventories mssi2 '
8440: ||' WHERE mssi2.sr_instance_code = mssi1.sr_instance_code'
8441: ||' AND NVL(mssi2.company_name, '||''''||NULL_CHAR||''''||') = '
8442: ||' NVL(mssi1.company_name, '||''''||NULL_CHAR||''''||')'
8443: ||' AND mssi2.organization_code = mssi1.organization_code'

Line 8472: 'UPDATE msc_st_sub_inventories mssi1 '

8468:
8469: -- Duplicate UDK validation for XML message
8470: v_sql_stmt := 28;
8471: lv_sql_stmt :=
8472: 'UPDATE msc_st_sub_inventories mssi1 '
8473: ||' SET process_flag = '||G_ERROR_FLG||','
8474: ||' error_text = '||''''||lv_message_text||''''
8475: ||' WHERE message_id < (SELECT MAX(message_id)'
8476: ||' FROM msc_st_sub_inventories mssi2'

Line 8476: ||' FROM msc_st_sub_inventories mssi2'

8472: 'UPDATE msc_st_sub_inventories mssi1 '
8473: ||' SET process_flag = '||G_ERROR_FLG||','
8474: ||' error_text = '||''''||lv_message_text||''''
8475: ||' WHERE message_id < (SELECT MAX(message_id)'
8476: ||' FROM msc_st_sub_inventories mssi2'
8477: ||' WHERE mssi2.sr_instance_code = mssi1.sr_instance_code '
8478: ||' AND NVL(mssi2.company_name, '||''''||NULL_CHAR||''''||') = '
8479: ||' NVL(mssi1.company_name, '||''''||NULL_CHAR||''''||')'
8480: ||' AND mssi2.organization_code = mssi1.organization_code'

Line 8520: 'UPDATE msc_st_sub_inventories '

8516: FROM DUAL;
8517:
8518: v_sql_stmt := 30;
8519: lv_sql_stmt :=
8520: 'UPDATE msc_st_sub_inventories '
8521: ||' SET batch_id = :lv_batch_id'
8522: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
8523: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE
8524: ||' AND sr_instance_code = :v_instance_code'

Line 8542: UPDATE msc_st_sub_inventories

8538: CLOSE c5;
8539:
8540: v_sql_stmt := 31;
8541: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8542: UPDATE msc_st_sub_inventories
8543: SET st_transaction_id = msc_st_sub_inventories_s.NEXTVAL ,
8544: refresh_id = v_refresh_id,
8545: last_update_date = v_current_date,
8546: last_updated_by = v_current_user,

Line 8543: SET st_transaction_id = msc_st_sub_inventories_s.NEXTVAL ,

8539:
8540: v_sql_stmt := 31;
8541: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8542: UPDATE msc_st_sub_inventories
8543: SET st_transaction_id = msc_st_sub_inventories_s.NEXTVAL ,
8544: refresh_id = v_refresh_id,
8545: last_update_date = v_current_date,
8546: last_updated_by = v_current_user,
8547: creation_date = v_current_date,

Line 8558: p_token_value1 => 'MSC_ST_SUB_INVENTORIES');

8554: p_error_code => 'MSC_PP_NO_DELETION',
8555: p_message_text => lv_message_text,
8556: p_error_text => lv_error_text,
8557: p_token1 => 'TABLE_NAME',
8558: p_token_value1 => 'MSC_ST_SUB_INVENTORIES');
8559:
8560: IF lv_return <> 0 THEN
8561: RAISE ex_logging_err;
8562: END IF;

Line 8567: 'UPDATE msc_st_sub_inventories '

8563:
8564: -- Deletion is not allowed for this table
8565: v_sql_stmt := 32;
8566: lv_sql_stmt :=
8567: 'UPDATE msc_st_sub_inventories '
8568: ||' SET process_flag = '||G_ERROR_FLG||','
8569: ||' error_text = '||''''||lv_message_text||''''
8570: ||' WHERE deleted_flag = '||SYS_YES
8571: ||' AND process_flag = '||G_IN_PROCESS

Line 8604: (p_table_name => 'MSC_ST_SUB_INVENTORIES',

8600: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') '
8601: ||' NOT IN(1,2)';
8602:
8603: lv_return := MSC_ST_UTIL.LOG_ERROR
8604: (p_table_name => 'MSC_ST_SUB_INVENTORIES',
8605: p_instance_code => v_instance_code,
8606: p_row => lv_column_names,
8607: p_severity => G_SEV_WARNING,
8608: p_message_text => lv_message_text,

Line 8635: 'UPDATE msc_st_sub_inventories '

8631:
8632: -- Error out records where subinventory_code is NULL
8633: v_sql_stmt := 33;
8634: lv_sql_stmt :=
8635: 'UPDATE msc_st_sub_inventories '
8636: ||' SET process_flag = '||G_ERROR_FLG||','
8637: ||' error_text = '||''''||lv_message_text||''''
8638: ||' WHERE sr_instance_code = :v_instance_code'
8639: ||' AND batch_id = :lv_batch_id'

Line 8665: (p_table_name => 'MSC_ST_SUB_INVENTORIES',

8661: END IF;
8662:
8663: -- Update organization_id
8664: lv_return := msc_st_util.derive_partner_org_id
8665: (p_table_name => 'MSC_ST_SUB_INVENTORIES',
8666: p_org_partner_name => 'ORGANIZATION_CODE',
8667: p_org_partner_id => 'ORGANIZATION_ID',
8668: p_instance_code => v_instance_code,
8669: p_partner_type => G_ORGANIZATION,

Line 8698: (p_table_name => 'MSC_ST_SUB_INVENTORIES',

8694:
8695: -- Default netting_type as 2 if NOT IN (1,2)
8696: lv_where_str := ' AND nvl(netting_type,'||NULL_VALUE||') NOT IN (1,2)';
8697: lv_return := MSC_ST_UTIL.LOG_ERROR
8698: (p_table_name => 'MSC_ST_SUB_INVENTORIES',
8699: p_instance_code => v_instance_code,
8700: p_row => lv_column_names,
8701: p_severity => G_SEV_WARNING,
8702: p_message_text => lv_message_text,

Line 8720: pEntityName => 'MSC_ST_SUB_INVENTORIES',

8716: (ERRBUF => lv_error_text,
8717: RETCODE => lv_return,
8718: pBatchID => lv_batch_id,
8719: pInstanceCode => v_instance_code,
8720: pEntityName => 'MSC_ST_SUB_INVENTORIES',
8721: pInstanceID => v_instance_id);
8722:
8723: IF NVL(lv_return,0) <> 0 THEN
8724: RAISE ex_logging_err;

Line 8729: (p_table_name => 'MSC_ST_SUB_INVENTORIES',

8725: END IF;
8726:
8727: -- Set the processf flag as Valid and poulate instance_id
8728: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
8729: (p_table_name => 'MSC_ST_SUB_INVENTORIES',
8730: p_instance_id => v_instance_id,
8731: p_instance_code => v_instance_code,
8732: p_process_flag => G_VALID,
8733: p_error_text => lv_error_text,

Line 8744: (p_table_name =>'MSC_ST_SUB_INVENTORIES',

8740:
8741: -- At the end calling the LOG_ERROR for logging all errored out records
8742:
8743: lv_return := MSC_ST_UTIL.LOG_ERROR
8744: (p_table_name =>'MSC_ST_SUB_INVENTORIES',
8745: p_instance_code =>v_instance_code,
8746: p_row =>lv_column_names,
8747: p_severity =>G_SEV_ERROR,
8748: p_message_text => NULL,

Line 29982: SELECT nvl(mssi.condition_type ,'G' ) from msc_st_sub_inventories mssi

29978: AND msi.sub_inventory_code = mss.subinventory_code
29979: AND msi.sr_instance_id = v_instance_id
29980: AND mss.sr_instance_code = v_instance_code
29981: UNION
29982: SELECT nvl(mssi.condition_type ,'G' ) from msc_st_sub_inventories mssi
29983: WHERE mssi.organization_code = mss.organization_code
29984: AND mssi.sub_inventory_code = mss.subinventory_code
29985: AND mssi.sr_instance_code = mss.sr_instance_code)
29986: WHERE rowid = lb_rowid(j);

Line 51014: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SUB_INVENTORIES');

51010: prec.tp_customer_flag:= SYS_YES;
51011: prec.tp_vendor_flag:= SYS_YES;
51012: prec.sourcing_rule_flag:= SYS_YES;
51013: End IF;
51014: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SUB_INVENTORIES');
51015: IF lv_count > 0 Then
51016: prec.sub_inventory_flag:= SYS_YES;
51017: End IF;
51018: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_GROUPS',p_company_name_col => FALSE);