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_BOM_PULL dependencies on STANDARD

Line 1845: ||' decode(x.ENTITY_TYPE,5,x.COPY_YIELD, x.YIELD), x.USAGE_RATE, x.Copy_op_seq_num, decode(x.ENTITY_TYPE,5,copy_STANDARD_OPERATION_CODE,Standard_Operation_Code), x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, '

1841: /* set the MTQ , Firm Flag, Scheduled flag */
1842: IF MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS115 THEN
1843: IF lv_lbj_details =1 Then
1844: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,x.scheduled_flag, x.QUANTITY_IN_QUEUE, x.QUANTITY_RUNNING, x.QUANTITY_WAITING_TO_MOVE, x.QUANTITY_COMPLETED,'
1845: ||' decode(x.ENTITY_TYPE,5,x.COPY_YIELD, x.YIELD), x.USAGE_RATE, x.Copy_op_seq_num, decode(x.ENTITY_TYPE,5,copy_STANDARD_OPERATION_CODE,Standard_Operation_Code), x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, '
1846: ||' x.ACTUAL_START_DATE, x.ROUTING_SEQUENCE_ID, ';
1847: ELSE
1848: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,x.scheduled_flag, x.QUANTITY_IN_QUEUE, x.QUANTITY_RUNNING, x.QUANTITY_WAITING_TO_MOVE, x.QUANTITY_COMPLETED,'
1849: ||' x.YIELD, x.USAGE_RATE, x.Operation_Seq_Num, x.Standard_Operation_Code, x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, x.ACTUAL_START_DATE, x.ROUTING_SEQUENCE_ID, ';

Line 1849: ||' x.YIELD, x.USAGE_RATE, x.Operation_Seq_Num, x.Standard_Operation_Code, x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, x.ACTUAL_START_DATE, x.ROUTING_SEQUENCE_ID, ';

1845: ||' decode(x.ENTITY_TYPE,5,x.COPY_YIELD, x.YIELD), x.USAGE_RATE, x.Copy_op_seq_num, decode(x.ENTITY_TYPE,5,copy_STANDARD_OPERATION_CODE,Standard_Operation_Code), x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, '
1846: ||' x.ACTUAL_START_DATE, x.ROUTING_SEQUENCE_ID, ';
1847: ELSE
1848: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,x.scheduled_flag, x.QUANTITY_IN_QUEUE, x.QUANTITY_RUNNING, x.QUANTITY_WAITING_TO_MOVE, x.QUANTITY_COMPLETED,'
1849: ||' x.YIELD, x.USAGE_RATE, x.Operation_Seq_Num, x.Standard_Operation_Code, x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, x.ACTUAL_START_DATE, x.ROUTING_SEQUENCE_ID, ';
1850: lv_cond_sql := ' AND (x.ENTITY_TYPE <> 5 OR x.OPERATION_SEQUENCE_ID is not null) ';
1851: END IF;
1852: ELSIF MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 THEN
1853: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL, ';

Line 1853: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL, ';

1849: ||' x.YIELD, x.USAGE_RATE, x.Operation_Seq_Num, x.Standard_Operation_Code, x.ACTIVITY_GROUP_ID, x.ALTERNATE_NUM, x.PRINCIPLE_FLAG, x.ACTUAL_START_DATE, x.ROUTING_SEQUENCE_ID, ';
1850: lv_cond_sql := ' AND (x.ENTITY_TYPE <> 5 OR x.OPERATION_SEQUENCE_ID is not null) ';
1851: END IF;
1852: ELSIF MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 THEN
1853: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL, ';
1854: ELSE
1855: v_temp_sql := ' NULL ,NULL ,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL, ';
1856: END IF;
1857: -- bug5996354

Line 1855: v_temp_sql := ' NULL ,NULL ,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL, ';

1851: END IF;
1852: ELSIF MSC_CL_PULL.v_apps_ver= MSC_UTIL.G_APPS110 THEN
1853: v_temp_sql := 'x.minimum_transfer_quantity,x.firm_flag,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL, ';
1854: ELSE
1855: v_temp_sql := ' NULL ,NULL ,NULL,NULL,NULL,NULL,NULL,NULL,NULL, x.OPERATION_SEQ_NUM, x.Standard_Operation_Code, NULL, NULL, NULL, NULL, NULL, ';
1856: END IF;
1857: -- bug5996354
1858: if MSC_UTIL.G_COLLECT_SRP_DATA = 'Y' and MSC_CL_PULL.v_apps_ver>= MSC_UTIL.G_APPS120 then
1859: MSC_CL_PULL.v_view_name := 'MRP_AP_NON_IRO_ERO_RES_REQ_V';

Line 2767: ||' STANDARD_OPERATION_ID,'

2763: ||' ( RESOURCE_ID,'
2764: ||' ORGANIZATION_ID,'
2765: ||' FROM_SETUP_ID,'
2766: ||' TO_SETUP_ID,'
2767: ||' STANDARD_OPERATION_ID,'
2768: ||' TRANSITION_TIME,'
2769: ||' TRANSITION_UOM,'
2770: ||' TRANSITION_PENALTY,'
2771: ||' DELETED_FLAG,'

Line 2779: ||' x.STANDARD_OPERATION_ID,'

2775: ||' x.RESOURCE_ID,'
2776: ||' x.ORGANIZATION_ID,'
2777: ||' x.FROM_SETUP_ID,'
2778: ||' x.TO_SETUP_ID,'
2779: ||' x.STANDARD_OPERATION_ID,'
2780: ||' x.TRANSITION_TIME,'
2781: ||' x.TRANSITION_UOM,'
2782: ||' x.TRANSITION_PENALTY,'
2783: ||' 2,'

Line 2801: ||' ( STANDARD_OPERATION_ID,'

2797: MSC_CL_PULL.v_view_name := 'MRP_AP_STD_OP_RESOURCES_V';
2798:
2799: v_sql_stmt:=
2800: ' insert into MSC_ST_STD_OP_RESOURCES'
2801: ||' ( STANDARD_OPERATION_ID,'
2802: ||' RESOURCE_ID,'
2803: ||' ORGANIZATION_ID,'
2804: ||' DEPARTMENT_ID,'
2805: ||' OPERATION_CODE,'

Line 2817: ||' x.STANDARD_OPERATION_ID,'

2813: ||' DELETED_FLAG,'
2814: ||' REFRESH_ID,'
2815: ||' SR_INSTANCE_ID)'
2816: ||' select'
2817: ||' x.STANDARD_OPERATION_ID,'
2818: ||' x.RESOURCE_ID,'
2819: ||' x.ORGANIZATION_ID,'
2820: ||' x.DEPARTMENT_ID,'
2821: ||' x.OPERATION_CODE,'