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.CSP_REPAIR_PO_PVT dependencies on WIP_DISCRETE_JOBS

Line 956: Update WIP_DISCRETE_JOBS

952: If nvl(l_RECEIVED_QTY,0) <= nvl(IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED,0)
953: and CSP_REPAIR_PO_HEADERS_rec.STATUS = 8
954: and l_wip_entity_id is not null then
955:
956: Update WIP_DISCRETE_JOBS
957: set START_QUANTITY = IO_QTY_RECEIVED_CHECK_REC.QUANTITY_RECEIVED,
958: LAST_UPDATE_DATE = SYSDATE
959: Where WIP_ENTITY_ID = CSP_REPAIR_PO_HEADERS_rec.WIP_ID;
960: End if;

Line 1189: FROM WIP_DISCRETE_JOBS

1185: */
1186:
1187: SELECT START_QUANTITY,QUANTITY_SCRAPPED
1188: INTO L_WIP_START_QUANTITY, L_WIP_QUANTITY_SCRAPPED
1189: FROM WIP_DISCRETE_JOBS
1190: WHERE CSP_REPAIR_PO_HEADERS_REC.WIP_ID = WIP_ENTITY_ID;
1191:
1192: L_WIP_REMAIN_QTY := NVL(L_WIP_START_QUANTITY,0) - (NVL(CSP_REPAIR_PO_HEADERS_REC.RECEIVED_QTY,0) + NVL(L_WIP_QUANTITY_SCRAPPED,0));
1193:

Line 1346: FROM WIP_DISCRETE_JOBS

1342: --LAST_UNIT_COMPLETION_DATE,
1343: CLASS_CODE,
1344: CSP_REPAIR_PO_HEADERS_rec.WIP_ID, --> Pass existing Wip_Entity_Id for update job status to "Complete"
1345: 'REPAIR_EXECUTION'||CSP_REPAIR_PO_HEADERS_rec.WIP_ID --> Pass existing job name(WIP_ENTITY_NAME) for update job status to "Complete"
1346: FROM WIP_DISCRETE_JOBS
1347: WHERE WIP_ENTITY_ID = CSP_REPAIR_PO_HEADERS_rec.WIP_ID;
1348:
1349: Exception
1350: When others then

Line 1365: /** If possible update WIP_DISCRETE_JOBS directly to update the quantity completed so far.

1361: End;
1362: --------------------- End comment on Nov-29-2005 -----------------
1363: */
1364:
1365: /** If possible update WIP_DISCRETE_JOBS directly to update the quantity completed so far.
1366: If FINAL_COMPLETION_FLAG = 'Y' and not automatically moved to complet status by mass upload
1367: update the STATUS_TYPE = 4(Complete) OR 12(Closed)
1368: **/
1369:

Line 1371: Update WIP_DISCRETE_JOBS

1367: update the STATUS_TYPE = 4(Complete) OR 12(Closed)
1368: **/
1369:
1370: /*
1371: Update WIP_DISCRETE_JOBS
1372: set --QUANTITY_COMPLETED = nvl(QUANTITY_COMPLETED,0) + PO_REQ_RECEIVED_QTY_rec.quantity_received,
1373: LAST_UPDATE_DATE = SYSDATE, STATUS_TYPE = nvl(l_wip_status_type,STATUS_TYPE),
1374: DATE_COMPLETED = DECODE(FINAL_COMPLETION_FLAG,'Y',SYSDATE,DATE_COMPLETED)
1375: Where WIP_ENTITY_ID = CSP_REPAIR_PO_HEADERS_rec.WIP_ID;

Line 1933: FROM WIP_DISCRETE_JOBS

1929: --LAST_UNIT_COMPLETION_DATE,
1930: CLASS_CODE,
1931: CSP_REPAIR_PO_SCRAP_rec.WIP_ID, --> Pass existing Wip_Entity_Id for update job status to "Complete"
1932: 'REPAIR_EXECUTION'||CSP_REPAIR_PO_SCRAP_rec.WIP_ID --> Pass existing job name(WIP_ENTITY_NAME) for update job status to "Complete"
1933: FROM WIP_DISCRETE_JOBS
1934: WHERE WIP_ENTITY_ID = CSP_REPAIR_PO_SCRAP_rec.WIP_ID;
1935: Exception
1936: When others then
1937: /*

Line 1959: / If possible update WIP_DISCRETE_JOBS directly for scrap transaction/

1955: ------------** Need to check whether this works or not **-------------
1956:
1957: If L_SCRAP_ADJUST_FLAG = 'SCRAP' then
1958:
1959: /** If possible update WIP_DISCRETE_JOBS directly for scrap transaction**/
1960: Update WIP_DISCRETE_JOBS
1961: set QUANTITY_SCRAPPED = nvl(QUANTITY_SCRAPPED,0) + L_SCRAP_ADJUST_QTY,
1962: LAST_UPDATE_DATE = SYSDATE, STATUS_TYPE = nvl(l_wip_status_type,STATUS_TYPE),
1963: DATE_COMPLETED = DECODE(FINAL_COMPLETION_FLAG,'Y',SYSDATE,DATE_COMPLETED)

Line 1960: Update WIP_DISCRETE_JOBS

1956:
1957: If L_SCRAP_ADJUST_FLAG = 'SCRAP' then
1958:
1959: /** If possible update WIP_DISCRETE_JOBS directly for scrap transaction**/
1960: Update WIP_DISCRETE_JOBS
1961: set QUANTITY_SCRAPPED = nvl(QUANTITY_SCRAPPED,0) + L_SCRAP_ADJUST_QTY,
1962: LAST_UPDATE_DATE = SYSDATE, STATUS_TYPE = nvl(l_wip_status_type,STATUS_TYPE),
1963: DATE_COMPLETED = DECODE(FINAL_COMPLETION_FLAG,'Y',SYSDATE,DATE_COMPLETED)
1964: Where WIP_ENTITY_ID = CSP_REPAIR_PO_SCRAP_rec.WIP_ID;

Line 1968: / If possible update WIP_DISCRETE_JOBS directly for adjustment transaction/

1964: Where WIP_ENTITY_ID = CSP_REPAIR_PO_SCRAP_rec.WIP_ID;
1965:
1966: Elsif L_SCRAP_ADJUST_FLAG = 'NEGATIVE ADJUSTMENT' then
1967:
1968: /** If possible update WIP_DISCRETE_JOBS directly for adjustment transaction**/
1969: Update WIP_DISCRETE_JOBS
1970: set QUANTITY_SCRAPPED = nvl(QUANTITY_SCRAPPED,0) + L_SCRAP_ADJUST_QTY,
1971: --QUANTITY_COMPLETED = nvl(QUANTITY_COMPLETED,0) + L_SCRAP_ADJUST_QTY,
1972: LAST_UPDATE_DATE = SYSDATE, STATUS_TYPE = nvl(l_wip_status_type,STATUS_TYPE),

Line 1969: Update WIP_DISCRETE_JOBS

1965:
1966: Elsif L_SCRAP_ADJUST_FLAG = 'NEGATIVE ADJUSTMENT' then
1967:
1968: /** If possible update WIP_DISCRETE_JOBS directly for adjustment transaction**/
1969: Update WIP_DISCRETE_JOBS
1970: set QUANTITY_SCRAPPED = nvl(QUANTITY_SCRAPPED,0) + L_SCRAP_ADJUST_QTY,
1971: --QUANTITY_COMPLETED = nvl(QUANTITY_COMPLETED,0) + L_SCRAP_ADJUST_QTY,
1972: LAST_UPDATE_DATE = SYSDATE, STATUS_TYPE = nvl(l_wip_status_type,STATUS_TYPE),
1973: DATE_COMPLETED = DECODE(FINAL_COMPLETION_FLAG,'Y',SYSDATE,DATE_COMPLETED)