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.

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_ST_SUB_INVENTORIES

Line 1126: ||' on MSC_ST_SUB_INVENTORIES '

1122: application_short_name => 'MSC',
1123: statement_type => AD_DDL.CREATE_INDEX,
1124: statement =>
1125: 'create index MSC_ST_SUB_INV_N1_'||v_instance_code
1126: ||' on MSC_ST_SUB_INVENTORIES '
1127: ||'( sr_instance_code, sub_inventory_code, organization_code ) '
1128: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1129: object_name =>'MSC_ST_SUB_INV_N1_'||v_instance_code);
1130:

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

1214:
1215:
1216: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNERS', v_instance_id, -1);
1217: msc_analyse_tables_pk.analyse_table( 'MSC_ST_TRADING_PARTNER_SITES', v_instance_id, -1);
1218: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SUB_INVENTORIES', v_instance_id, -1);
1219: msc_analyse_tables_pk.analyse_table( 'MSC_ST_LOCATION_ASSOCIATIONS', v_instance_id, -1);
1220: msc_analyse_tables_pk.analyse_table( 'MSC_ST_PARTNER_CONTACTS', v_instance_id, -1);
1221:
1222: END IF;

Line 6301: FROM msc_st_sub_inventories

6297: AND deleted_flag = SYS_NO;
6298:
6299: CURSOR c5(p_batch_id NUMBER) IS
6300: SELECT rowid
6301: FROM msc_st_sub_inventories
6302: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
6303: AND sr_instance_code = v_instance_code
6304: AND batch_id = p_batch_id;
6305:

Line 8545: --Validation for MSC_ST_SUB_INVENTORIES

8541: END IF ; -- v_install_msd
8542: COMMIT;
8543: END LOOP;
8544:
8545: --Validation for MSC_ST_SUB_INVENTORIES
8546:
8547:
8548: lv_return := MSC_ST_UTIL.GET_ERROR_MESSAGE
8549: (p_app_short_name => 'MSC',

Line 8561: 'UPDATE msc_st_sub_inventories mssi1 '

8557:
8558: -- UDK validations
8559: v_sql_stmt := 29;
8560: lv_sql_stmt :=
8561: 'UPDATE msc_st_sub_inventories mssi1 '
8562: ||' SET process_flag = '||G_ERROR_FLG||','
8563: ||' error_text = '||''''||lv_message_text||''''
8564: ||' WHERE EXISTS( SELECT 1 '
8565: ||' FROM msc_st_sub_inventories mssi2 '

Line 8565: ||' FROM msc_st_sub_inventories mssi2 '

8561: 'UPDATE msc_st_sub_inventories mssi1 '
8562: ||' SET process_flag = '||G_ERROR_FLG||','
8563: ||' error_text = '||''''||lv_message_text||''''
8564: ||' WHERE EXISTS( SELECT 1 '
8565: ||' FROM msc_st_sub_inventories mssi2 '
8566: ||' WHERE mssi2.sr_instance_code = mssi1.sr_instance_code'
8567: ||' AND NVL(mssi2.company_name, '||''''||NULL_CHAR||''''||') = '
8568: ||' NVL(mssi1.company_name, '||''''||NULL_CHAR||''''||')'
8569: ||' AND mssi2.organization_code = mssi1.organization_code'

Line 8598: 'UPDATE msc_st_sub_inventories mssi1 '

8594:
8595: -- Duplicate UDK validation for XML message
8596: v_sql_stmt := 28;
8597: lv_sql_stmt :=
8598: 'UPDATE msc_st_sub_inventories mssi1 '
8599: ||' SET process_flag = '||G_ERROR_FLG||','
8600: ||' error_text = '||''''||lv_message_text||''''
8601: ||' WHERE message_id < (SELECT MAX(message_id)'
8602: ||' FROM msc_st_sub_inventories mssi2'

Line 8602: ||' FROM msc_st_sub_inventories mssi2'

8598: 'UPDATE msc_st_sub_inventories mssi1 '
8599: ||' SET process_flag = '||G_ERROR_FLG||','
8600: ||' error_text = '||''''||lv_message_text||''''
8601: ||' WHERE message_id < (SELECT MAX(message_id)'
8602: ||' FROM msc_st_sub_inventories mssi2'
8603: ||' WHERE mssi2.sr_instance_code = mssi1.sr_instance_code '
8604: ||' AND NVL(mssi2.company_name, '||''''||NULL_CHAR||''''||') = '
8605: ||' NVL(mssi1.company_name, '||''''||NULL_CHAR||''''||')'
8606: ||' AND mssi2.organization_code = mssi1.organization_code'

Line 8646: 'UPDATE msc_st_sub_inventories '

8642: FROM DUAL;
8643:
8644: v_sql_stmt := 30;
8645: lv_sql_stmt :=
8646: 'UPDATE msc_st_sub_inventories '
8647: ||' SET batch_id = :lv_batch_id'
8648: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
8649: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE
8650: ||' AND sr_instance_code = :v_instance_code'

Line 8668: UPDATE msc_st_sub_inventories

8664: CLOSE c5;
8665:
8666: v_sql_stmt := 31;
8667: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8668: UPDATE msc_st_sub_inventories
8669: SET st_transaction_id = msc_st_sub_inventories_s.NEXTVAL ,
8670: refresh_id = v_refresh_id,
8671: last_update_date = v_current_date,
8672: last_updated_by = v_current_user,

Line 8669: SET st_transaction_id = msc_st_sub_inventories_s.NEXTVAL ,

8665:
8666: v_sql_stmt := 31;
8667: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
8668: UPDATE msc_st_sub_inventories
8669: SET st_transaction_id = msc_st_sub_inventories_s.NEXTVAL ,
8670: refresh_id = v_refresh_id,
8671: last_update_date = v_current_date,
8672: last_updated_by = v_current_user,
8673: creation_date = v_current_date,

Line 8684: p_token_value1 => 'MSC_ST_SUB_INVENTORIES');

8680: p_error_code => 'MSC_PP_NO_DELETION',
8681: p_message_text => lv_message_text,
8682: p_error_text => lv_error_text,
8683: p_token1 => 'TABLE_NAME',
8684: p_token_value1 => 'MSC_ST_SUB_INVENTORIES');
8685:
8686: IF lv_return <> 0 THEN
8687: RAISE ex_logging_err;
8688: END IF;

Line 8693: 'UPDATE msc_st_sub_inventories '

8689:
8690: -- Deletion is not allowed for this table
8691: v_sql_stmt := 32;
8692: lv_sql_stmt :=
8693: 'UPDATE msc_st_sub_inventories '
8694: ||' SET process_flag = '||G_ERROR_FLG||','
8695: ||' error_text = '||''''||lv_message_text||''''
8696: ||' WHERE deleted_flag = '||SYS_YES
8697: ||' AND process_flag = '||G_IN_PROCESS

Line 8730: (p_table_name => 'MSC_ST_SUB_INVENTORIES',

8726: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') '
8727: ||' NOT IN(1,2)';
8728:
8729: lv_return := MSC_ST_UTIL.LOG_ERROR
8730: (p_table_name => 'MSC_ST_SUB_INVENTORIES',
8731: p_instance_code => v_instance_code,
8732: p_row => lv_column_names,
8733: p_severity => G_SEV_WARNING,
8734: p_message_text => lv_message_text,

Line 8761: 'UPDATE msc_st_sub_inventories '

8757:
8758: -- Error out records where subinventory_code is NULL
8759: v_sql_stmt := 33;
8760: lv_sql_stmt :=
8761: 'UPDATE msc_st_sub_inventories '
8762: ||' SET process_flag = '||G_ERROR_FLG||','
8763: ||' error_text = '||''''||lv_message_text||''''
8764: ||' WHERE sr_instance_code = :v_instance_code'
8765: ||' AND batch_id = :lv_batch_id'

Line 8791: (p_table_name => 'MSC_ST_SUB_INVENTORIES',

8787: END IF;
8788:
8789: -- Update organization_id
8790: lv_return := msc_st_util.derive_partner_org_id
8791: (p_table_name => 'MSC_ST_SUB_INVENTORIES',
8792: p_org_partner_name => 'ORGANIZATION_CODE',
8793: p_org_partner_id => 'ORGANIZATION_ID',
8794: p_instance_code => v_instance_code,
8795: p_partner_type => G_ORGANIZATION,

Line 8824: (p_table_name => 'MSC_ST_SUB_INVENTORIES',

8820:
8821: -- Default netting_type as 2 if NOT IN (1,2)
8822: lv_where_str := ' AND nvl(netting_type,'||NULL_VALUE||') NOT IN (1,2)';
8823: lv_return := MSC_ST_UTIL.LOG_ERROR
8824: (p_table_name => 'MSC_ST_SUB_INVENTORIES',
8825: p_instance_code => v_instance_code,
8826: p_row => lv_column_names,
8827: p_severity => G_SEV_WARNING,
8828: p_message_text => lv_message_text,

Line 8846: pEntityName => 'MSC_ST_SUB_INVENTORIES',

8842: (ERRBUF => lv_error_text,
8843: RETCODE => lv_return,
8844: pBatchID => lv_batch_id,
8845: pInstanceCode => v_instance_code,
8846: pEntityName => 'MSC_ST_SUB_INVENTORIES',
8847: pInstanceID => v_instance_id);
8848:
8849: IF NVL(lv_return,0) <> 0 THEN
8850: RAISE ex_logging_err;

Line 8855: (p_table_name => 'MSC_ST_SUB_INVENTORIES',

8851: END IF;
8852:
8853: -- Set the processf flag as Valid and poulate instance_id
8854: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
8855: (p_table_name => 'MSC_ST_SUB_INVENTORIES',
8856: p_instance_id => v_instance_id,
8857: p_instance_code => v_instance_code,
8858: p_process_flag => G_VALID,
8859: p_error_text => lv_error_text,

Line 8870: (p_table_name =>'MSC_ST_SUB_INVENTORIES',

8866:
8867: -- At the end calling the LOG_ERROR for logging all errored out records
8868:
8869: lv_return := MSC_ST_UTIL.LOG_ERROR
8870: (p_table_name =>'MSC_ST_SUB_INVENTORIES',
8871: p_instance_code =>v_instance_code,
8872: p_row =>lv_column_names,
8873: p_severity =>G_SEV_ERROR,
8874: p_message_text => NULL,

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

34311: AND msi.sub_inventory_code = mss.subinventory_code
34312: AND msi.sr_instance_id = v_instance_id
34313: AND mss.sr_instance_code = v_instance_code
34314: UNION
34315: SELECT nvl(mssi.condition_type ,'G' ) from msc_st_sub_inventories mssi
34316: WHERE mssi.organization_code = mss.organization_code
34317: AND mssi.sub_inventory_code = mss.subinventory_code
34318: AND mssi.sr_instance_code = mss.sr_instance_code)
34319: WHERE rowid = lb_rowid(j);

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

55932: prec.tp_customer_flag:= SYS_YES;
55933: prec.tp_vendor_flag:= SYS_YES;
55934: prec.sourcing_rule_flag:= SYS_YES;
55935: End IF;
55936: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SUB_INVENTORIES');
55937: IF lv_count > 0 Then
55938: prec.sub_inventory_flag:= SYS_YES;
55939: End IF;
55940: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_GROUPS',p_company_name_col => FALSE);