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.MRP_RESCHEDULE_CMRO_WO_PS dependencies on WIP_OPERATIONS

Line 1916: from wip_operations wo

1912: ,L_EAM_OP_TBL(y).ATTRIBUTE13
1913: ,L_EAM_OP_TBL(y).ATTRIBUTE14
1914: ,L_EAM_OP_TBL(y).ATTRIBUTE15
1915: ,L_EAM_OP_TBL(y).long_description
1916: from wip_operations wo
1917: where
1918: wo.wip_entity_id = OP_CUR_TBL(y).WIP_ENTITY_ID
1919: and wo.OPERATION_SEQ_NUM = OP_CUR_TBL(y).OPERATION_SEQ_NUM
1920: and wo.organization_id = OP_CUR_TBL(y).ORGANIZATION_ID

Line 2438: ||' FROM WIP_OPERATIONS WO '

2434: ||' ,WO.WIP_ENTITY_ID '
2435: ||' ,WO.ORGANIZATION_ID '
2436: ||' ,WO.SCHEDULED_QUANTITY '
2437: ||' ,3 '
2438: ||' FROM WIP_OPERATIONS WO '
2439: ||' WHERE WO.WIP_ENTITY_ID = :V_WIP_ENTITY_ID'
2440: ||' AND WO.ORGANIZATION_ID = :V_ORGANIZATION_ID'
2441: ||' AND WO.OPERATION_SEQ_NUM NOT IN '
2442: ||' (select operation_seq_num '

Line 2465: ' from WIP_OPERATIONS is '||SQL%RowCount);

2461: ,V_ORGANIZATION_ID;
2462:
2463: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,
2464: 'Number of missing records fetched'||
2465: ' from WIP_OPERATIONS is '||SQL%RowCount);
2466: --missing resources load_type = 1
2467:
2468: lv_stmt2 := 'INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE'||g_dblink||'('
2469: ||' GROUP_ID '