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.WIP_DEFAULT_SHOPFLOORMOVE dependencies on WIP_ENTITIES

Line 12: g_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;

8: -- Package global used within the package.
9:
10: g_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type;
11: g_OSP_rec WIP_Transaction_PUB.Res_Rec_Type;
12: g_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type;
13: g_osp_mov_details WIP_Transaction_PUB.OSP_Move_Details_Type;
14:
15: -- Get functions.
16:

Line 19: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type :=

15: -- Get functions.
16:
17: PROCEDURE get_we_attr
18: IS
19: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type :=
20: WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;
21: BEGIN
22:
23: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN

Line 20: WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;

16:
17: PROCEDURE get_we_attr
18: IS
19: l_Wip_Entities_rec WIP_Work_Order_PUB.Wip_Entities_Rec_Type :=
20: WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;
21: BEGIN
22:
23: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN
24:

Line 25: l_Wip_Entities_rec := WIP_Wip_Entities_Util.Query_Row(g_ShopFloorMove_rec.wip_entity_id);

21: BEGIN
22:
23: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN
24:
25: l_Wip_Entities_rec := WIP_Wip_Entities_Util.Query_Row(g_ShopFloorMove_rec.wip_entity_id);
26: IF g_ShopFloorMove_rec.wip_entity_name IS NULL THEN
27: g_Wip_Entities_rec.wip_entity_name := l_Wip_Entities_rec.wip_entity_name;
28: END IF;
29: IF g_ShopFloorMove_rec.primary_item_id IS NULL THEN

Line 27: g_Wip_Entities_rec.wip_entity_name := l_Wip_Entities_rec.wip_entity_name;

23: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN
24:
25: l_Wip_Entities_rec := WIP_Wip_Entities_Util.Query_Row(g_ShopFloorMove_rec.wip_entity_id);
26: IF g_ShopFloorMove_rec.wip_entity_name IS NULL THEN
27: g_Wip_Entities_rec.wip_entity_name := l_Wip_Entities_rec.wip_entity_name;
28: END IF;
29: IF g_ShopFloorMove_rec.primary_item_id IS NULL THEN
30: g_Wip_Entities_rec.primary_item_id := l_Wip_Entities_rec.primary_item_id;
31: END IF;

Line 30: g_Wip_Entities_rec.primary_item_id := l_Wip_Entities_rec.primary_item_id;

26: IF g_ShopFloorMove_rec.wip_entity_name IS NULL THEN
27: g_Wip_Entities_rec.wip_entity_name := l_Wip_Entities_rec.wip_entity_name;
28: END IF;
29: IF g_ShopFloorMove_rec.primary_item_id IS NULL THEN
30: g_Wip_Entities_rec.primary_item_id := l_Wip_Entities_rec.primary_item_id;
31: END IF;
32: IF g_ShopFloorMove_rec.entity_type IS NULL THEN
33: g_Wip_Entities_rec.entity_type := l_Wip_Entities_rec.entity_type;
34: END IF;

Line 33: g_Wip_Entities_rec.entity_type := l_Wip_Entities_rec.entity_type;

29: IF g_ShopFloorMove_rec.primary_item_id IS NULL THEN
30: g_Wip_Entities_rec.primary_item_id := l_Wip_Entities_rec.primary_item_id;
31: END IF;
32: IF g_ShopFloorMove_rec.entity_type IS NULL THEN
33: g_Wip_Entities_rec.entity_type := l_Wip_Entities_rec.entity_type;
34: END IF;
35:
36: END IF;
37:

Line 54: from WIP_ENTITIES WE

50: for move-completions and return-moves
51: */
52:
53: select count(*) into x_valid_ez_complete
54: from WIP_ENTITIES WE
55: where we.wip_entity_id = p_wip_entity_id
56: and we.organization_id = p_org_id
57: and (((we.entity_type = WIP_CONSTANTS.DISCRETE)
58: and not exists (select 'X'

Line 87: from wip_entities we, mtl_system_items msi

83: -- If it's discrete, and does not have a default lot then can't move_complete/return
84: -- if it's repetitive then can't move_complete/return_move
85:
86: select count(*) into x_valid_ez_complete
87: from wip_entities we, mtl_system_items msi
88: where we.wip_entity_id = p_wip_entity_id
89: and we.organization_id = p_org_id
90: and msi.inventory_item_id = we.primary_item_id
91: and msi.organization_id = we.organization_id

Line 112: from MTL_SYSTEM_ITEMS msi, WIP_ENTITIES we

108: x_valid_ez_complete OUT NOCOPY NUMBER) IS
109: BEGIN
110:
111: select count(*) into x_valid_ez_complete
112: from MTL_SYSTEM_ITEMS msi, WIP_ENTITIES we
113: where we.organization_id = p_org_id
114: and we.wip_entity_id = p_wip_entity_id
115: and msi.inventory_item_id = we.primary_item_id
116: and msi.organization_id = we.organization_id

Line 165: from wip_entities we

161: /*item revision must exist as a BOM revision */
162: /* Fix for bug 4095809: Need to do the comparison only if a bill
163: is referenced in the job ie., common_bill_sequence_id IS NOT NULL */
164: select count(*) into x_valid_ez_complete
165: from wip_entities we
166: where we.wip_entity_id = p_wip_entity_id
167: and we.organization_id = p_org_id
168: and exists (
169: select 'X'

Line 292: from mtl_system_items msi, wip_entities we

288:
289: begin
290: select msi.lot_control_code, msi.shelf_life_code
291: into l_lot_control_code, l_shelf_life_code
292: from mtl_system_items msi, wip_entities we
293: where we.wip_entity_id = p_wip_entity_id
294: and we.organization_id = p_org_id
295: and msi.organization_id = we.organization_id
296: and INVENTORY_ITEM_ID = we.primary_item_id;

Line 650: IF g_Wip_Entities_rec.entity_type IS NOT NULL THEN

646: IF g_OSP_rec.entity_type IS NOT NULL THEN
647: RETURN g_OSP_rec.entity_type;
648: END IF;
649:
650: IF g_Wip_Entities_rec.entity_type IS NOT NULL THEN
651: RETURN g_Wip_Entities_rec.entity_type;
652: END IF;
653:
654: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN

Line 651: RETURN g_Wip_Entities_rec.entity_type;

647: RETURN g_OSP_rec.entity_type;
648: END IF;
649:
650: IF g_Wip_Entities_rec.entity_type IS NOT NULL THEN
651: RETURN g_Wip_Entities_rec.entity_type;
652: END IF;
653:
654: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN
655: get_we_attr();

Line 1453: IF g_Wip_Entities_rec.primary_item_id IS NOT NULL THEN

1449: IF g_OSP_rec.primary_item_id IS NOT NULL THEN
1450: RETURN g_OSP_rec.primary_item_id;
1451: END IF;
1452:
1453: IF g_Wip_Entities_rec.primary_item_id IS NOT NULL THEN
1454: RETURN g_Wip_Entities_rec.primary_item_id;
1455: END IF;
1456:
1457: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN

Line 1454: RETURN g_Wip_Entities_rec.primary_item_id;

1450: RETURN g_OSP_rec.primary_item_id;
1451: END IF;
1452:
1453: IF g_Wip_Entities_rec.primary_item_id IS NOT NULL THEN
1454: RETURN g_Wip_Entities_rec.primary_item_id;
1455: END IF;
1456:
1457: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN
1458: get_we_attr();

Line 2016: IF g_Wip_Entities_rec.wip_entity_name IS NOT NULL THEN

2012: IF g_OSP_rec.wip_entity_name IS NOT NULL THEN
2013: RETURN g_OSP_rec.wip_entity_name;
2014: END IF;
2015:
2016: IF g_Wip_Entities_rec.wip_entity_name IS NOT NULL THEN
2017: RETURN g_Wip_Entities_rec.wip_entity_name;
2018: END IF;
2019:
2020: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN

Line 2017: RETURN g_Wip_Entities_rec.wip_entity_name;

2013: RETURN g_OSP_rec.wip_entity_name;
2014: END IF;
2015:
2016: IF g_Wip_Entities_rec.wip_entity_name IS NOT NULL THEN
2017: RETURN g_Wip_Entities_rec.wip_entity_name;
2018: END IF;
2019:
2020: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN
2021: get_we_attr();

Line 2135: g_Wip_Entities_rec := WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;

2131: -- Initialize global variables
2132:
2133: g_ShopFloorMove_rec := WIP_Transaction_PUB.G_MISS_SHOPFLOORMOVE_REC;
2134: g_OSP_rec := WIP_Transaction_PUB.G_MISS_RES_REC;
2135: g_Wip_Entities_rec := WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;
2136: g_osp_mov_details := WIP_Transaction_PUB.G_MISS_OSP_MOVE_DET_REC;
2137:
2138: g_ShopFloorMove_rec := p_ShopFloorMove_rec;
2139: g_OSP_rec := p_OSP_rec;