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 1089: FROM WIP_DISCRETE_JOBS

1085: --LAST_UNIT_COMPLETION_DATE,
1086: CLASS_CODE,
1087: CSP_REPAIR_PO_HEADERS_rec.WIP_ID, --> Pass existing Wip_Entity_Id for update job status to "Complete"
1088: 'REPAIR_EXECUTION'||CSP_REPAIR_PO_HEADERS_rec.WIP_ID --> Pass existing job name(WIP_ENTITY_NAME) for update job status to "Complete"
1089: FROM WIP_DISCRETE_JOBS
1090: WHERE WIP_ENTITY_ID = CSP_REPAIR_PO_HEADERS_rec.WIP_ID;
1091:
1092: Exception
1093: When others then

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

1104: End;
1105: --------------------- End comment on Nov-29-2005 -----------------
1106: */
1107:
1108: /** If possible update WIP_DISCRETE_JOBS directly to update the quantity completed so far.
1109: If FINAL_COMPLETION_FLAG = 'Y' and not automatically moved to complet status by mass upload
1110: update the STATUS_TYPE = 4(Complete) OR 12(Closed)
1111: **/
1112:

Line 1114: Update WIP_DISCRETE_JOBS

1110: update the STATUS_TYPE = 4(Complete) OR 12(Closed)
1111: **/
1112:
1113: /*
1114: Update WIP_DISCRETE_JOBS
1115: set --QUANTITY_COMPLETED = nvl(QUANTITY_COMPLETED,0) + PO_REQ_RECEIVED_QTY_rec.quantity_received,
1116: LAST_UPDATE_DATE = SYSDATE, STATUS_TYPE = nvl(l_wip_status_type,STATUS_TYPE),
1117: DATE_COMPLETED = DECODE(FINAL_COMPLETION_FLAG,'Y',SYSDATE,DATE_COMPLETED)
1118: Where WIP_ENTITY_ID = CSP_REPAIR_PO_HEADERS_rec.WIP_ID;

Line 1628: FROM WIP_DISCRETE_JOBS

1624: --LAST_UNIT_COMPLETION_DATE,
1625: CLASS_CODE,
1626: CSP_REPAIR_PO_SCRAP_rec.WIP_ID, --> Pass existing Wip_Entity_Id for update job status to "Complete"
1627: 'REPAIR_EXECUTION'||CSP_REPAIR_PO_SCRAP_rec.WIP_ID --> Pass existing job name(WIP_ENTITY_NAME) for update job status to "Complete"
1628: FROM WIP_DISCRETE_JOBS
1629: WHERE WIP_ENTITY_ID = CSP_REPAIR_PO_SCRAP_rec.WIP_ID;
1630: Exception
1631: When others then
1632: /*

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

1650: ------------** Need to check whether this works or not **-------------
1651:
1652: If L_SCRAP_ADJUST_FLAG = 'SCRAP' then
1653:
1654: /** If possible update WIP_DISCRETE_JOBS directly for scrap transaction**/
1655: Update WIP_DISCRETE_JOBS
1656: set QUANTITY_SCRAPPED = nvl(QUANTITY_SCRAPPED,0) + L_SCRAP_ADJUST_QTY,
1657: LAST_UPDATE_DATE = SYSDATE, STATUS_TYPE = nvl(l_wip_status_type,STATUS_TYPE),
1658: DATE_COMPLETED = DECODE(FINAL_COMPLETION_FLAG,'Y',SYSDATE,DATE_COMPLETED)

Line 1655: Update WIP_DISCRETE_JOBS

1651:
1652: If L_SCRAP_ADJUST_FLAG = 'SCRAP' then
1653:
1654: /** If possible update WIP_DISCRETE_JOBS directly for scrap transaction**/
1655: Update WIP_DISCRETE_JOBS
1656: set QUANTITY_SCRAPPED = nvl(QUANTITY_SCRAPPED,0) + L_SCRAP_ADJUST_QTY,
1657: LAST_UPDATE_DATE = SYSDATE, STATUS_TYPE = nvl(l_wip_status_type,STATUS_TYPE),
1658: DATE_COMPLETED = DECODE(FINAL_COMPLETION_FLAG,'Y',SYSDATE,DATE_COMPLETED)
1659: Where WIP_ENTITY_ID = CSP_REPAIR_PO_SCRAP_rec.WIP_ID;

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

1659: Where WIP_ENTITY_ID = CSP_REPAIR_PO_SCRAP_rec.WIP_ID;
1660:
1661: Elsif L_SCRAP_ADJUST_FLAG = 'ADJUSTMENT' then
1662:
1663: /** If possible update WIP_DISCRETE_JOBS directly for adjustment transaction**/
1664: Update WIP_DISCRETE_JOBS
1665: set QUANTITY_SCRAPPED = nvl(QUANTITY_SCRAPPED,0) + L_SCRAP_ADJUST_QTY,
1666: --QUANTITY_COMPLETED = nvl(QUANTITY_COMPLETED,0) + L_SCRAP_ADJUST_QTY,
1667: LAST_UPDATE_DATE = SYSDATE, STATUS_TYPE = nvl(l_wip_status_type,STATUS_TYPE),

Line 1664: Update WIP_DISCRETE_JOBS

1660:
1661: Elsif L_SCRAP_ADJUST_FLAG = 'ADJUSTMENT' then
1662:
1663: /** If possible update WIP_DISCRETE_JOBS directly for adjustment transaction**/
1664: Update WIP_DISCRETE_JOBS
1665: set QUANTITY_SCRAPPED = nvl(QUANTITY_SCRAPPED,0) + L_SCRAP_ADJUST_QTY,
1666: --QUANTITY_COMPLETED = nvl(QUANTITY_COMPLETED,0) + L_SCRAP_ADJUST_QTY,
1667: LAST_UPDATE_DATE = SYSDATE, STATUS_TYPE = nvl(l_wip_status_type,STATUS_TYPE),
1668: DATE_COMPLETED = DECODE(FINAL_COMPLETION_FLAG,'Y',SYSDATE,DATE_COMPLETED)