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.CTO_WIP_WRAPPER dependencies on WIP_CONSTANTS

Line 1398: and wei.load_type = WIP_CONSTANTS.CREATE_JOB

1394: and oet.language = (select language_code
1395: from fnd_languages
1396: where installed_flag = 'B')
1397: and mso.segment3 = lSourceCode
1398: and wei.load_type = WIP_CONSTANTS.CREATE_JOB
1399: and wei.organization_id = oel.ship_from_org_id
1400: and wei.process_phase = WIP_CONSTANTS.ML_COMPLETE
1401: and wei.process_status = WIP_CONSTANTS.COMPLETED -- 3202934
1402: and msi.inventory_item_id = oel.inventory_item_id

Line 1400: and wei.process_phase = WIP_CONSTANTS.ML_COMPLETE

1396: where installed_flag = 'B')
1397: and mso.segment3 = lSourceCode
1398: and wei.load_type = WIP_CONSTANTS.CREATE_JOB
1399: and wei.organization_id = oel.ship_from_org_id
1400: and wei.process_phase = WIP_CONSTANTS.ML_COMPLETE
1401: and wei.process_status = WIP_CONSTANTS.COMPLETED -- 3202934
1402: and msi.inventory_item_id = oel.inventory_item_id
1403: and msi.organization_id = oel.ship_from_org_id;
1404:

Line 1401: and wei.process_status = WIP_CONSTANTS.COMPLETED -- 3202934

1397: and mso.segment3 = lSourceCode
1398: and wei.load_type = WIP_CONSTANTS.CREATE_JOB
1399: and wei.organization_id = oel.ship_from_org_id
1400: and wei.process_phase = WIP_CONSTANTS.ML_COMPLETE
1401: and wei.process_status = WIP_CONSTANTS.COMPLETED -- 3202934
1402: and msi.inventory_item_id = oel.inventory_item_id
1403: and msi.organization_id = oel.ship_from_org_id;
1404:
1405: BEGIN

Line 1547: set process_phase = WIP_CONSTANTS.ML_VALIDATION,

1543: where wip_entity_id = WorkOrder_Rec.wip_entity_id;
1544:
1545: l_stmt_num := 110;
1546: update wip_job_schedule_interface
1547: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
1548: process_status = WIP_CONSTANTS.RUNNING
1549: where wip_entity_id = WorkOrder_Rec.wip_entity_id
1550: and group_id = p_wip_seq;
1551:

Line 1548: process_status = WIP_CONSTANTS.RUNNING

1544:
1545: l_stmt_num := 110;
1546: update wip_job_schedule_interface
1547: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
1548: process_status = WIP_CONSTANTS.RUNNING
1549: where wip_entity_id = WorkOrder_Rec.wip_entity_id
1550: and group_id = p_wip_seq;
1551:
1552: else

Line 1630: set process_phase = WIP_CONSTANTS.ML_VALIDATION,

1626: where wip_entity_id = WorkOrder_Rec.wip_entity_id;
1627:
1628: l_stmt_num := 140;
1629: update wip_job_schedule_interface
1630: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
1631: process_status = WIP_CONSTANTS.RUNNING
1632: where wip_entity_id = WorkOrder_Rec.wip_entity_id
1633: and group_id = p_wip_seq;
1634:

Line 1631: process_status = WIP_CONSTANTS.RUNNING

1627:
1628: l_stmt_num := 140;
1629: update wip_job_schedule_interface
1630: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
1631: process_status = WIP_CONSTANTS.RUNNING
1632: where wip_entity_id = WorkOrder_Rec.wip_entity_id
1633: and group_id = p_wip_seq;
1634:
1635: end if; /* respond to change order not successful */

Line 1779: and (wjs.process_status = WIP_CONSTANTS.PENDING

1775: from wip_job_schedule_interface wjs,
1776: oe_order_lines_all oel
1777: where oel.line_id = pLineId
1778: and wjs.source_line_id = oel.line_id
1779: and (wjs.process_status = WIP_CONSTANTS.PENDING
1780: or wjs.process_status = WIP_CONSTANTS.RUNNING
1781: or wjs.process_status = WIP_CONSTANTS.COMPLETED);
1782:
1783: /* begin bugfix 2868148 : This cursor calculates supply created by flow schedule. */

Line 1780: or wjs.process_status = WIP_CONSTANTS.RUNNING

1776: oe_order_lines_all oel
1777: where oel.line_id = pLineId
1778: and wjs.source_line_id = oel.line_id
1779: and (wjs.process_status = WIP_CONSTANTS.PENDING
1780: or wjs.process_status = WIP_CONSTANTS.RUNNING
1781: or wjs.process_status = WIP_CONSTANTS.COMPLETED);
1782:
1783: /* begin bugfix 2868148 : This cursor calculates supply created by flow schedule. */
1784:

Line 1781: or wjs.process_status = WIP_CONSTANTS.COMPLETED);

1777: where oel.line_id = pLineId
1778: and wjs.source_line_id = oel.line_id
1779: and (wjs.process_status = WIP_CONSTANTS.PENDING
1780: or wjs.process_status = WIP_CONSTANTS.RUNNING
1781: or wjs.process_status = WIP_CONSTANTS.COMPLETED);
1782:
1783: /* begin bugfix 2868148 : This cursor calculates supply created by flow schedule. */
1784:
1785: cursor flow_supply is