APPS.MSC_CL_PRE_PROCESS dependencies on STANDARD

Line 22164: ||'STANDARD_COST ||''~''||'

22160: ||'WEIGHT_UOM ||''~''||'
22161: ||'VOLUME_UOM ||''~''||'
22162: ||'PRODUCT_FAMILY_ID ||''~''||'
22163: ||'ATP_RULE_CODE ||''~''||'
22164: ||'STANDARD_COST ||''~''||'
22165: ||'CARRYING_COST ||''~''||'
22166: ||'ORDER_COST ||''~''||'
22167: ||'DMD_LATENESS_COST ||''~''||'
22168: ||'SS_PENALTY_COST ||''~''||'

Line 33723: -- Populating standard_operation_id

33719:
33720: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
33721: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
33722:
33723: -- Populating standard_operation_id
33724:
33725: v_sql_stmt:= 07;
33726:
33727: lv_sql_stmt :=

Line 33729: ||' SET standard_operation_id= (SELECT local_id'

33725: v_sql_stmt:= 07;
33726:
33727: lv_sql_stmt :=
33728: 'UPDATE msc_st_setup_transitions msst'
33729: ||' SET standard_operation_id= (SELECT local_id'
33730: ||' FROM msc_local_id_setup mlis'
33731: ||' WHERE mlis.char1 = msst.sr_instance_code'
33732: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||')'
33733: || '=NVL(msst.company_name,'||''''||NULL_CHAR||''''||') '

Line 33735: ||' AND mlis.char4 = msst.standard_operation_code'

33731: ||' WHERE mlis.char1 = msst.sr_instance_code'
33732: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||')'
33733: || '=NVL(msst.company_name,'||''''||NULL_CHAR||''''||') '
33734: ||' AND mlis.char3 = msst.organization_code'
33735: ||' AND mlis.char4 = msst.standard_operation_code'
33736: ||' AND mlis.entity_name = ''STANDARD_OPERATION_ID'')'
33737: ||' WHERE msst.sr_instance_code = :v_instance_code'
33738: ||' AND msst.process_flag ='|| G_IN_PROCESS
33739: ||' AND msst.batch_id = :lv_batch_id';

Line 33736: ||' AND mlis.entity_name = ''STANDARD_OPERATION_ID'')'

33732: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||')'
33733: || '=NVL(msst.company_name,'||''''||NULL_CHAR||''''||') '
33734: ||' AND mlis.char3 = msst.organization_code'
33735: ||' AND mlis.char4 = msst.standard_operation_code'
33736: ||' AND mlis.entity_name = ''STANDARD_OPERATION_ID'')'
33737: ||' WHERE msst.sr_instance_code = :v_instance_code'
33738: ||' AND msst.process_flag ='|| G_IN_PROCESS
33739: ||' AND msst.batch_id = :lv_batch_id';
33740:

Line 44536: ||' STANDARD_OPERATION_CODE ||''~''||'

44532: ||' NET_PLANNING_PERCENT ||''~''||'
44533: ||' SETUP_DURATION ||''~''||'
44534: ||' TEAR_DOWN_DURATION ||''~''||'
44535: ||' UOM_CODE ||''~''||'
44536: ||' STANDARD_OPERATION_CODE ||''~''||'
44537: ||' DELETED_FLAG ||''~''||'
44538: ||' COMPANY_NAME ';
44539:
44540:

Line 47290: | Non-Standard Job 7 |

47286: | in the msc_st_supplies table. Order_types considered are |
47287: | Supply Source Order Type |
47288: | -------------------------------------------- |
47289: | Discrete Job 3 |
47290: | Non-Standard Job 7 |
47291: | Flow Schedule 27 |
47292: | Discrete job by-product 14 |
47293: | Nonstandard job by-product 15 |
47294: +==========================================================================*/

Line 47293: | Nonstandard job by-product 15 |

47289: | Discrete Job 3 |
47290: | Non-Standard Job 7 |
47291: | Flow Schedule 27 |
47292: | Discrete job by-product 14 |
47293: | Nonstandard job by-product 15 |
47294: +==========================================================================*/
47295: PROCEDURE LOAD_WO_SUPPLY IS
47296: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
47297: lb_rowid RowidTab;

Line 51820: ||' STANDARD_OPERATION_CODE ||''~''||'

51816: ||' OPERATION_LEAD_TIME_PERCENT ||''~''||'
51817: ||' CUMULATIVE_YIELD ||''~''||'
51818: ||' REVERSE_CUMULATIVE_YIELD ||''~''||'
51819: ||' NET_PLANNING_PERCENT ||''~''||'
51820: ||' STANDARD_OPERATION_CODE ||''~''||'
51821: ||' DELETED_FLAG ||''~''||'
51822: ||' COMPANY_NAME ';
51823:
51824: LOOP