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.WSMPOPRN dependencies on WIP_OPERATION_YIELDS

Line 1255: DELETE FROM WIP_OPERATION_YIELDS

1251: AND PROGRAM_ID = -999
1252: AND ORGANIZATION_ID = X_Organization_Id;
1253:
1254: l_stat_num := 40;
1255: DELETE FROM WIP_OPERATION_YIELDS
1256: WHERE WIP_ENTITY_ID = X_Wip_Entity_id
1257: --AND OPERATION_SEQ_NUM > X_From_Op
1258: AND OPERATION_SEQ_NUM = X_To_Op
1259: AND PROGRAM_ID = -999

Line 1400: -- so the previous select statment will not insert row into wip_operation_yields,

1396: -- End bugfix 1523334
1397:
1398: -- bugfix 1611094
1399: -- for jumping operation, the operation_seq_id insert into the wip_operations table will be null,
1400: -- so the previous select statment will not insert row into wip_operation_yields,
1401: -- changed where clause, so that new record will be insert into the wip_operation_yields with jumping operation
1402:
1403: -- The below insert is used for Costing Changes (OP Yield)
1404: l_stat_num := 20;

Line 1401: -- changed where clause, so that new record will be insert into the wip_operation_yields with jumping operation

1397:
1398: -- bugfix 1611094
1399: -- for jumping operation, the operation_seq_id insert into the wip_operations table will be null,
1400: -- so the previous select statment will not insert row into wip_operation_yields,
1401: -- changed where clause, so that new record will be insert into the wip_operation_yields with jumping operation
1402:
1403: -- The below insert is used for Costing Changes (OP Yield)
1404: l_stat_num := 20;
1405: INSERT INTO WIP_OPERATION_YIELDS

Line 1405: INSERT INTO WIP_OPERATION_YIELDS

1401: -- changed where clause, so that new record will be insert into the wip_operation_yields with jumping operation
1402:
1403: -- The below insert is used for Costing Changes (OP Yield)
1404: l_stat_num := 20;
1405: INSERT INTO WIP_OPERATION_YIELDS
1406: (WIP_ENTITY_ID, OPERATION_SEQ_NUM, ORGANIZATION_ID,
1407: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
1408: CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
1409: PROGRAM_APPLICATION_ID, PROGRAM_ID,PROGRAM_UPDATE_DATE,

Line 2399: INSERT INTO WIP_OPERATION_YIELDS

2395:
2396: l_stmt_num := 20;
2397: /******
2398: Bug 3571019 - Get SCRAP_ACCOUNT, EST_SCRAP_ABSORB_ACCOUNT from WCO instead of BD
2399: INSERT INTO WIP_OPERATION_YIELDS
2400: (WIP_ENTITY_ID, OPERATION_SEQ_NUM, ORGANIZATION_ID,
2401: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
2402: CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2403: PROGRAM_APPLICATION_ID, PROGRAM_ID,PROGRAM_UPDATE_DATE,

Line 2424: INSERT INTO WIP_OPERATION_YIELDS

2420: AND WO.ORGANIZATION_ID = p_org_id
2421: AND WO.DEPARTMENT_ID = BD.DEPARTMENT_ID; --bugfix 1611094
2422: *******/
2423:
2424: INSERT INTO WIP_OPERATION_YIELDS
2425: (WIP_ENTITY_ID, OPERATION_SEQ_NUM, ORGANIZATION_ID,
2426: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,
2427: CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID,
2428: PROGRAM_APPLICATION_ID, PROGRAM_ID,PROGRAM_UPDATE_DATE,