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.INV_LABEL_PVT10 dependencies on WIP_FLOW_SCHEDULES

Line 14: /* WFS_TYPE : transaction is WIP_FLOW_SCHEDULES ID */

10:
11: /* MMTT_TYPE : transaction is MTL_MATERIAL_TRANSACTIONS_TEMP ID */
12: /* MTI_TYPE : transaction is MTL_TRANSACTION_INTERFACE ID */
13: /* MTRL_TYPE : transaction is MTL_TXN_REQUEST_LINES ID */
14: /* WFS_TYPE : transaction is WIP_FLOW_SCHEDULES ID */
15:
16: MMTT_TYPE CONSTANT NUMBER := 1;
17: MTI_TYPE CONSTANT NUMBER := 2;
18: MTRL_TYPE CONSTANT NUMBER := 3;

Line 37: p_wip_entity_id wip_flow_schedules.wip_entity_id%TYPE,

33: END trace;
34:
35: PROCEDURE get_data(
36: x_out_tbl IN OUT NOCOPY output_tbl_type,
37: p_wip_entity_id wip_flow_schedules.wip_entity_id%TYPE,
38: p_schedule_number wip_flow_schedules.schedule_number%TYPE,
39: p_inventory_item_id mtl_system_items.inventory_item_id%TYPE,
40: p_organization_id mtl_system_items.organization_id%TYPE,
41: p_subinventory_code wip_flow_schedules.completion_subinventory%TYPE,

Line 38: p_schedule_number wip_flow_schedules.schedule_number%TYPE,

34:
35: PROCEDURE get_data(
36: x_out_tbl IN OUT NOCOPY output_tbl_type,
37: p_wip_entity_id wip_flow_schedules.wip_entity_id%TYPE,
38: p_schedule_number wip_flow_schedules.schedule_number%TYPE,
39: p_inventory_item_id mtl_system_items.inventory_item_id%TYPE,
40: p_organization_id mtl_system_items.organization_id%TYPE,
41: p_subinventory_code wip_flow_schedules.completion_subinventory%TYPE,
42: p_locator_id wip_flow_schedules.completion_locator_id%TYPE

Line 41: p_subinventory_code wip_flow_schedules.completion_subinventory%TYPE,

37: p_wip_entity_id wip_flow_schedules.wip_entity_id%TYPE,
38: p_schedule_number wip_flow_schedules.schedule_number%TYPE,
39: p_inventory_item_id mtl_system_items.inventory_item_id%TYPE,
40: p_organization_id mtl_system_items.organization_id%TYPE,
41: p_subinventory_code wip_flow_schedules.completion_subinventory%TYPE,
42: p_locator_id wip_flow_schedules.completion_locator_id%TYPE
43: ) IS
44:
45: i NUMBER;

Line 42: p_locator_id wip_flow_schedules.completion_locator_id%TYPE

38: p_schedule_number wip_flow_schedules.schedule_number%TYPE,
39: p_inventory_item_id mtl_system_items.inventory_item_id%TYPE,
40: p_organization_id mtl_system_items.organization_id%TYPE,
41: p_subinventory_code wip_flow_schedules.completion_subinventory%TYPE,
42: p_locator_id wip_flow_schedules.completion_locator_id%TYPE
43: ) IS
44:
45: i NUMBER;
46: l_wip_entity_id wip_flow_schedules.wip_entity_id%TYPE := NULL;

Line 46: l_wip_entity_id wip_flow_schedules.wip_entity_id%TYPE := NULL;

42: p_locator_id wip_flow_schedules.completion_locator_id%TYPE
43: ) IS
44:
45: i NUMBER;
46: l_wip_entity_id wip_flow_schedules.wip_entity_id%TYPE := NULL;
47:
48: CURSOR item_curs IS
49: SELECT
50: NULL cost_group,

Line 123: FROM WIP_FLOW_SCHEDULES wflow,

119: wflow_we.wip_entity_name,
120: Wflow_wl.line_code,
121: wflow.End_item_unit_number,
122: wflow.Current_line_operation
123: FROM WIP_FLOW_SCHEDULES wflow,
124: WIP_ENTITIES wflow_we,
125: MTL_ITEM_LOCATIONS_KFV wflow_loc,
126: MTL_KANBAN_CARDS wflow_mkc,
127: WIP_LINES wflow_wl

Line 136: FROM WIP_FLOW_SCHEDULES

132: AND Wflow.line_id = wflow_wl.line_id(+);
133:
134: CURSOR flow_entity_curs IS
135: SELECT wip_entity_id
136: FROM WIP_FLOW_SCHEDULES
137: WHERE wip_entity_id = p_wip_entity_id ;
138:
139:
140: BEGIN

Line 182: FROM WIP_FLOW_SCHEDULES

178: x_out_tbl(2027).datbuf := p_schedule_number;
179:
180: BEGIN
181: SELECT wip_entity_id INTO l_wip_entity_id
182: FROM WIP_FLOW_SCHEDULES
183: WHERE schedule_number = p_schedule_number ;
184:
185: EXCEPTION
186: WHEN OTHERS THEN

Line 1803: schedule_number wip_flow_schedules.schedule_number%TYPE,

1799: sale_line_id mtl_material_transactions_temp.demand_source_line%TYPE,
1800: kanban_card_id mtl_material_transactions_temp.kanban_card_id%TYPE,
1801: lpn_id mtl_material_transactions_temp.lpn_id%TYPE,
1802: wip_entity_id mtl_material_transactions_temp.transaction_source_id%TYPE,
1803: schedule_number wip_flow_schedules.schedule_number%TYPE,
1804: lot_control_code mtl_system_items.lot_control_code%TYPE,
1805: serial_number_control_code mtl_system_items.serial_number_control_code%TYPE,
1806: transaction_id mtl_material_transactions_temp.transaction_temp_id%TYPE
1807: );

Line 1880: WIP_FLOW_SCHEDULES wfs

1876: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
1877: MTL_TRANSACTION_LOTS_TEMP mtlt,
1878: MTL_SYSTEM_ITEMS msi,
1879: WIP_ENTITIES WE,
1880: WIP_FLOW_SCHEDULES wfs
1881: WHERE mmtt.transaction_temp_id = l_transaction_id
1882: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1883: AND mmtt.organization_id = msi.organization_id
1884: AND mmtt.inventory_item_id = msi.inventory_item_id

Line 1927: WIP_FLOW_SCHEDULES wfs,

1923: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
1924: MTL_TRANSACTION_LOTS_TEMP mtlt,
1925: MTL_SYSTEM_ITEMS msi,
1926: WIP_ENTITIES WE,
1927: WIP_FLOW_SCHEDULES wfs,
1928: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt_orig
1929: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)
1930: AND mmtt.organization_id = msi.organization_id
1931: AND mmtt.inventory_item_id = msi.inventory_item_id

Line 1979: WIP_FLOW_SCHEDULES wfs

1975: -- this depends on WIP's fix on bug 2904857
1976: MTL_TRANSACTION_LOTS_INTERFACE mtli,
1977: --MTL_TRANSACTION_LOTS_TEMP mtlt,
1978: MTL_SYSTEM_ITEMS msi,
1979: WIP_FLOW_SCHEDULES wfs
1980: WHERE mti.transaction_interface_id = l_transaction_id
1981: -- AND mti.transaction_interface_id = mtli.transaction_interface_id(+) -- Bug 2576424 : joabraha
1982: -- AND mti.transaction_interface_id = mtlt.transaction_temp_id(+) -- Bug 2576424 : joabraha
1983: -- Bug 2904877, change back to using MTLI,

Line 2061: FROM WIP_FLOW_SCHEDULES wfs,

2057: wfs.schedule_number schedule_number,
2058: msi.lot_control_code,
2059: msi.serial_number_control_code,
2060: mmtt.transaction_temp_id transaction_id
2061: FROM WIP_FLOW_SCHEDULES wfs,
2062: MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
2063: MTL_TRANSACTION_LOTS_TEMP mtlt,
2064: MTL_SYSTEM_ITEMS msi,
2065: WIP_ENTITIES WE

Line 2105: FROM wip_flow_schedules wfs,

2101: wfs.schedule_number schedule_number,
2102: msi.lot_control_code,
2103: msi.serial_number_control_code,
2104: mmt.transaction_id transaction_id
2105: FROM wip_flow_schedules wfs,
2106: mtl_material_transactions mmt,
2107: mtl_transaction_lot_numbers mtln,
2108: wip_entities we,
2109: mtl_system_items msi

Line 2124: -- from WIP_FLOW_SCHEDULES

2120: AND wfs.wip_entity_id = l_transaction_id;
2121:
2122: -- Bug 2728468 Adhoc printing enabled for schedules that is not completed yet.
2123: -- Added new cursor of flow_schedule_wfs_curs to retrieve schedule information
2124: -- from WIP_FLOW_SCHEDULES
2125: CURSOR flow_schedule_wfs_curs IS
2126: SELECT wfs.primary_item_id inventory_item_id,
2127: wfs.organization_id organization_id,
2128: wfs.completion_subinventory subinventory_code,

Line 2151: FROM wip_flow_schedules wfs,

2147: wfs.schedule_number schedule_number,
2148: msi.lot_control_code,
2149: msi.serial_number_control_code,
2150: NULL transaction_id
2151: FROM wip_flow_schedules wfs,
2152: wip_entities we,
2153: mtl_system_items msi
2154: WHERE wfs.organization_id = msi.organization_id
2155: AND wfs.primary_item_id = msi.inventory_item_id

Line 2587: -- from WIP_FLOW_SCHEDULES

2583: CLOSE flow_schedule_mmt_curs;
2584:
2585: -- Bug 2728468 Adhoc printing enabled for schedules that is not completed yet.
2586: -- Added new cursor of flow_schedule_wfs_curs to retrieve schedule information
2587: -- from WIP_FLOW_SCHEDULES
2588: IF (l_in_rec.transaction_id IS NULL) THEN
2589: l_counter := 0;
2590: -- When no MMT record for the schedule, query directly from WFS
2591: OPEN flow_schedule_wfs_curs;