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 614: IF g_Wip_Entities_rec.entity_type IS NOT NULL THEN

610: IF g_OSP_rec.entity_type IS NOT NULL THEN
611: RETURN g_OSP_rec.entity_type;
612: END IF;
613:
614: IF g_Wip_Entities_rec.entity_type IS NOT NULL THEN
615: RETURN g_Wip_Entities_rec.entity_type;
616: END IF;
617:
618: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN

Line 615: RETURN g_Wip_Entities_rec.entity_type;

611: RETURN g_OSP_rec.entity_type;
612: END IF;
613:
614: IF g_Wip_Entities_rec.entity_type IS NOT NULL THEN
615: RETURN g_Wip_Entities_rec.entity_type;
616: END IF;
617:
618: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN
619: get_we_attr();

Line 1394: IF g_Wip_Entities_rec.primary_item_id IS NOT NULL THEN

1390: IF g_OSP_rec.primary_item_id IS NOT NULL THEN
1391: RETURN g_OSP_rec.primary_item_id;
1392: END IF;
1393:
1394: IF g_Wip_Entities_rec.primary_item_id IS NOT NULL THEN
1395: RETURN g_Wip_Entities_rec.primary_item_id;
1396: END IF;
1397:
1398: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN

Line 1395: RETURN g_Wip_Entities_rec.primary_item_id;

1391: RETURN g_OSP_rec.primary_item_id;
1392: END IF;
1393:
1394: IF g_Wip_Entities_rec.primary_item_id IS NOT NULL THEN
1395: RETURN g_Wip_Entities_rec.primary_item_id;
1396: END IF;
1397:
1398: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN
1399: get_we_attr();

Line 1957: IF g_Wip_Entities_rec.wip_entity_name IS NOT NULL THEN

1953: IF g_OSP_rec.wip_entity_name IS NOT NULL THEN
1954: RETURN g_OSP_rec.wip_entity_name;
1955: END IF;
1956:
1957: IF g_Wip_Entities_rec.wip_entity_name IS NOT NULL THEN
1958: RETURN g_Wip_Entities_rec.wip_entity_name;
1959: END IF;
1960:
1961: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN

Line 1958: RETURN g_Wip_Entities_rec.wip_entity_name;

1954: RETURN g_OSP_rec.wip_entity_name;
1955: END IF;
1956:
1957: IF g_Wip_Entities_rec.wip_entity_name IS NOT NULL THEN
1958: RETURN g_Wip_Entities_rec.wip_entity_name;
1959: END IF;
1960:
1961: IF g_ShopFloorMove_rec.wip_entity_id IS NOT NULL THEN
1962: get_we_attr();

Line 2076: g_Wip_Entities_rec := WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;

2072: -- Initialize global variables
2073:
2074: g_ShopFloorMove_rec := WIP_Transaction_PUB.G_MISS_SHOPFLOORMOVE_REC;
2075: g_OSP_rec := WIP_Transaction_PUB.G_MISS_RES_REC;
2076: g_Wip_Entities_rec := WIP_Work_Order_PUB.G_MISS_WIP_ENTITIES_REC;
2077: g_osp_mov_details := WIP_Transaction_PUB.G_MISS_OSP_MOVE_DET_REC;
2078:
2079: g_ShopFloorMove_rec := p_ShopFloorMove_rec;
2080: g_OSP_rec := p_OSP_rec;