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 1542: and wei.load_type = WIP_CONSTANTS.CREATE_JOB

1538: and oet.language = (select language_code
1539: from fnd_languages
1540: where installed_flag = 'B')
1541: and mso.segment3 = lSourceCode
1542: and wei.load_type = WIP_CONSTANTS.CREATE_JOB
1543: and wei.organization_id = oel.ship_from_org_id
1544: and wei.process_phase = WIP_CONSTANTS.ML_COMPLETE
1545: -- bug 9314772.added warning status jobs for creating reservations.pdube
1546: -- and wei.process_status = WIP_CONSTANTS.COMPLETED -- 3202934

Line 1544: and wei.process_phase = WIP_CONSTANTS.ML_COMPLETE

1540: where installed_flag = 'B')
1541: and mso.segment3 = lSourceCode
1542: and wei.load_type = WIP_CONSTANTS.CREATE_JOB
1543: and wei.organization_id = oel.ship_from_org_id
1544: and wei.process_phase = WIP_CONSTANTS.ML_COMPLETE
1545: -- bug 9314772.added warning status jobs for creating reservations.pdube
1546: -- and wei.process_status = WIP_CONSTANTS.COMPLETED -- 3202934
1547: and wei.process_status IN (WIP_CONSTANTS.COMPLETED,WIP_CONSTANTS.WARNING)
1548: and msi.inventory_item_id = oel.inventory_item_id

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

1542: and wei.load_type = WIP_CONSTANTS.CREATE_JOB
1543: and wei.organization_id = oel.ship_from_org_id
1544: and wei.process_phase = WIP_CONSTANTS.ML_COMPLETE
1545: -- bug 9314772.added warning status jobs for creating reservations.pdube
1546: -- and wei.process_status = WIP_CONSTANTS.COMPLETED -- 3202934
1547: and wei.process_status IN (WIP_CONSTANTS.COMPLETED,WIP_CONSTANTS.WARNING)
1548: and msi.inventory_item_id = oel.inventory_item_id
1549: and msi.organization_id = oel.ship_from_org_id;
1550:

Line 1547: and wei.process_status IN (WIP_CONSTANTS.COMPLETED,WIP_CONSTANTS.WARNING)

1543: and wei.organization_id = oel.ship_from_org_id
1544: and wei.process_phase = WIP_CONSTANTS.ML_COMPLETE
1545: -- bug 9314772.added warning status jobs for creating reservations.pdube
1546: -- and wei.process_status = WIP_CONSTANTS.COMPLETED -- 3202934
1547: and wei.process_status IN (WIP_CONSTANTS.COMPLETED,WIP_CONSTANTS.WARNING)
1548: and msi.inventory_item_id = oel.inventory_item_id
1549: and msi.organization_id = oel.ship_from_org_id;
1550:
1551: BEGIN

Line 1693: set process_phase = WIP_CONSTANTS.ML_VALIDATION,

1689: where wip_entity_id = WorkOrder_Rec.wip_entity_id;
1690:
1691: l_stmt_num := 110;
1692: update wip_job_schedule_interface
1693: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
1694: process_status = WIP_CONSTANTS.RUNNING
1695: where wip_entity_id = WorkOrder_Rec.wip_entity_id
1696: and group_id = p_wip_seq;
1697:

Line 1694: process_status = WIP_CONSTANTS.RUNNING

1690:
1691: l_stmt_num := 110;
1692: update wip_job_schedule_interface
1693: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
1694: process_status = WIP_CONSTANTS.RUNNING
1695: where wip_entity_id = WorkOrder_Rec.wip_entity_id
1696: and group_id = p_wip_seq;
1697:
1698: else

Line 1776: set process_phase = WIP_CONSTANTS.ML_VALIDATION,

1772: where wip_entity_id = WorkOrder_Rec.wip_entity_id;
1773:
1774: l_stmt_num := 140;
1775: update wip_job_schedule_interface
1776: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
1777: process_status = WIP_CONSTANTS.RUNNING
1778: where wip_entity_id = WorkOrder_Rec.wip_entity_id
1779: and group_id = p_wip_seq;
1780:

Line 1777: process_status = WIP_CONSTANTS.RUNNING

1773:
1774: l_stmt_num := 140;
1775: update wip_job_schedule_interface
1776: set process_phase = WIP_CONSTANTS.ML_VALIDATION,
1777: process_status = WIP_CONSTANTS.RUNNING
1778: where wip_entity_id = WorkOrder_Rec.wip_entity_id
1779: and group_id = p_wip_seq;
1780:
1781: end if; /* respond to change order not successful */

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

1921: from wip_job_schedule_interface wjs,
1922: oe_order_lines_all oel
1923: where oel.line_id = pLineId
1924: and wjs.source_line_id = oel.line_id
1925: and (wjs.process_status = WIP_CONSTANTS.PENDING
1926: or wjs.process_status = WIP_CONSTANTS.RUNNING
1927: or wjs.process_status = WIP_CONSTANTS.COMPLETED)
1928: --Bugfix 12397938
1929: and wjs.source_code = 'WICDOL';

Line 1926: or wjs.process_status = WIP_CONSTANTS.RUNNING

1922: oe_order_lines_all oel
1923: where oel.line_id = pLineId
1924: and wjs.source_line_id = oel.line_id
1925: and (wjs.process_status = WIP_CONSTANTS.PENDING
1926: or wjs.process_status = WIP_CONSTANTS.RUNNING
1927: or wjs.process_status = WIP_CONSTANTS.COMPLETED)
1928: --Bugfix 12397938
1929: and wjs.source_code = 'WICDOL';
1930:

Line 1927: or wjs.process_status = WIP_CONSTANTS.COMPLETED)

1923: where oel.line_id = pLineId
1924: and wjs.source_line_id = oel.line_id
1925: and (wjs.process_status = WIP_CONSTANTS.PENDING
1926: or wjs.process_status = WIP_CONSTANTS.RUNNING
1927: or wjs.process_status = WIP_CONSTANTS.COMPLETED)
1928: --Bugfix 12397938
1929: and wjs.source_code = 'WICDOL';
1930:
1931: /* begin bugfix 2868148 : This cursor calculates supply created by flow schedule. */