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_ITEM_INQ dependencies on INV_ITEM_INQ

Line 1: PACKAGE BODY inv_ITEM_INQ AS

1: PACKAGE BODY inv_ITEM_INQ AS
2: /* $Header: INVIQWMB.pls 120.15 2008/02/13 12:00:39 abaid noship $ */
3:
4: FUNCTION get_status_code (
5: p_status_id mtl_material_statuses_vl.status_id%TYPE

Line 25: PROCEDURE INV_ITEM_INQUIRIES (

21: * Obtain onhand information
22: * INV org
23: **************************/
24: /* THIS PROCEDURE IS NOT BEING USED ANYWHERE */
25: PROCEDURE INV_ITEM_INQUIRIES (
26: x_item_inquiries OUT NOCOPY t_genref,
27: p_Organization_Id IN NUMBER,
28: p_Inventory_Item_Id IN NUMBER DEFAULT NULL,
29: p_Revision IN VARCHAR2 DEFAULT NULL,

Line 46: inv_ITEM_INQ.get_available_qty(

42: milk.concatenated_segments, -- Locator Concatenated Segments
43: moq.lot_number,
44: msik.primary_uom_code,
45: sum(nvl(moq.primary_transaction_quantity, 0)),
46: inv_ITEM_INQ.get_available_qty(
47: moq.organization_id,
48: moq.inventory_item_id,
49: moq.revision,
50: moq.subinventory_code,

Line 56: inv_item_inq.get_status_code(msub.status_id),

52: moq.lot_number,null,
53: decode(moq.revision, NULL, 'FALSE', 'TRUE'),
54: decode(msik.lot_control_code, 2, 'TRUE', 'FALSE'),
55: decode(msik.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE')),
56: inv_item_inq.get_status_code(msub.status_id),
57: inv_item_inq.get_status_code(milk.status_id),
58: inv_item_inq.get_status_code(mln.status_id),
59: msik.serial_number_control_code,
60: moq.cost_group_id

Line 57: inv_item_inq.get_status_code(milk.status_id),

53: decode(moq.revision, NULL, 'FALSE', 'TRUE'),
54: decode(msik.lot_control_code, 2, 'TRUE', 'FALSE'),
55: decode(msik.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE')),
56: inv_item_inq.get_status_code(msub.status_id),
57: inv_item_inq.get_status_code(milk.status_id),
58: inv_item_inq.get_status_code(mln.status_id),
59: msik.serial_number_control_code,
60: moq.cost_group_id
61:

Line 58: inv_item_inq.get_status_code(mln.status_id),

54: decode(msik.lot_control_code, 2, 'TRUE', 'FALSE'),
55: decode(msik.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE')),
56: inv_item_inq.get_status_code(msub.status_id),
57: inv_item_inq.get_status_code(milk.status_id),
58: inv_item_inq.get_status_code(mln.status_id),
59: msik.serial_number_control_code,
60: moq.cost_group_id
61:
62: FROM mtl_onhand_quantities_detail moq,

Line 98: inv_item_inq.get_available_qty(

94: GROUP BY moq.organization_id, moq.inventory_item_id,
95: msik.concatenated_segments, moq.revision, msik.description,
96: moq.subinventory_code, moq.locator_id, milk.concatenated_segments,
97: moq.lot_number, msik.primary_uom_code,
98: inv_item_inq.get_available_qty(
99: moq.organization_id,
100: moq.inventory_item_id,
101: moq.revision,
102: moq.subinventory_code,

Line 108: inv_item_inq.get_status_code(msub.status_id),

104: moq.lot_number, null,
105: decode(moq.revision, NULL, 'FALSE', 'TRUE'),
106: decode(msik.lot_control_code, 2, 'TRUE', 'FALSE'),
107: decode(msik.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE')),
108: inv_item_inq.get_status_code(msub.status_id),
109: inv_item_inq.get_status_code(milk.status_id),
110: inv_item_inq.get_status_code(mln.status_id),
111: msik.serial_number_control_code,
112: moq.cost_group_id;

Line 109: inv_item_inq.get_status_code(milk.status_id),

105: decode(moq.revision, NULL, 'FALSE', 'TRUE'),
106: decode(msik.lot_control_code, 2, 'TRUE', 'FALSE'),
107: decode(msik.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE')),
108: inv_item_inq.get_status_code(msub.status_id),
109: inv_item_inq.get_status_code(milk.status_id),
110: inv_item_inq.get_status_code(mln.status_id),
111: msik.serial_number_control_code,
112: moq.cost_group_id;
113:

Line 110: inv_item_inq.get_status_code(mln.status_id),

106: decode(msik.lot_control_code, 2, 'TRUE', 'FALSE'),
107: decode(msik.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE')),
108: inv_item_inq.get_status_code(msub.status_id),
109: inv_item_inq.get_status_code(milk.status_id),
110: inv_item_inq.get_status_code(mln.status_id),
111: msik.serial_number_control_code,
112: moq.cost_group_id;
113:
114: x_status := 'C';

Line 116: END INV_ITEM_INQUIRIES;

112: moq.cost_group_id;
113:
114: x_status := 'C';
115: x_message := 'Records found';
116: END INV_ITEM_INQUIRIES;
117:
118: /******************************************
119: * Obtain onhand information
120: * WMS org, provide cost group information

Line 151: inv_item_inq.get_available_qty(

147: b.lot_number,
148: b.lot_status,
149: b.primary_uom_code,
150: b.sum_txn_qty,
151: inv_item_inq.get_available_qty(
152: b.organization_id,
153: b.inventory_item_id,
154: b.revision,
155: b.subinventory_code,

Line 162: inv_item_inq.get_packed_quantity(

158: b.cost_group_id,
159: decode(b.revision, NULL, 'FALSE', 'TRUE'),
160: decode(b.lot_control_code, 2, 'TRUE', 'FALSE'),
161: decode(b.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE')),
162: inv_item_inq.get_packed_quantity(
163: b.organization_id, b.inventory_item_id, b.revision,
164: b.subinventory_code, b.locator_id, b.lot_number, b.cost_Group_id),
165: inv_item_inq.get_loose_quantity(
166: b.organization_id, b.inventory_item_id, b.revision,

Line 165: inv_item_inq.get_loose_quantity(

161: decode(b.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE')),
162: inv_item_inq.get_packed_quantity(
163: b.organization_id, b.inventory_item_id, b.revision,
164: b.subinventory_code, b.locator_id, b.lot_number, b.cost_Group_id),
165: inv_item_inq.get_loose_quantity(
166: b.organization_id, b.inventory_item_id, b.revision,
167: b.subinventory_code, b.locator_id, b.lot_number, b.cost_Group_id),
168: b.serial_number_control_code
169: FROM

Line 463: inv_item_inq.get_status_code(msub.status_id),

459: nvl(mmtt.cost_group_id, 0),
460: ccg.cost_group,
461: lpn.outermost_lpn_id,
462: lpn3.license_plate_number ,
463: inv_item_inq.get_status_code(msub.status_id),
464: inv_item_inq.get_status_code(milk.status_id),
465: to_char(NULL), --Lot Status
466: lpn.lpn_context,
467: to_char(NULL), --Dock Door segs

Line 464: inv_item_inq.get_status_code(milk.status_id),

460: ccg.cost_group,
461: lpn.outermost_lpn_id,
462: lpn3.license_plate_number ,
463: inv_item_inq.get_status_code(msub.status_id),
464: inv_item_inq.get_status_code(milk.status_id),
465: to_char(NULL), --Lot Status
466: lpn.lpn_context,
467: to_char(NULL), --Dock Door segs
468: msiv.serial_number_control_code,

Line 531: inv_item_inq.get_status_code(msub.status_id),

527: mmtt.transaction_uom,
528: nvl(mmtt.cost_group_id, 0),
529: ccg.cost_group,
530: lpn.outermost_lpn_id, lpn3.license_plate_number ,
531: inv_item_inq.get_status_code(msub.status_id),
532: inv_item_inq.get_status_code(milk.status_id),
533: inv_item_inq.get_status_code(mln.status_id),
534: lpn.lpn_context,
535: to_char(NULL), --Dock Door segs

Line 532: inv_item_inq.get_status_code(milk.status_id),

528: nvl(mmtt.cost_group_id, 0),
529: ccg.cost_group,
530: lpn.outermost_lpn_id, lpn3.license_plate_number ,
531: inv_item_inq.get_status_code(msub.status_id),
532: inv_item_inq.get_status_code(milk.status_id),
533: inv_item_inq.get_status_code(mln.status_id),
534: lpn.lpn_context,
535: to_char(NULL), --Dock Door segs
536: msiv.serial_number_control_code,

Line 533: inv_item_inq.get_status_code(mln.status_id),

529: ccg.cost_group,
530: lpn.outermost_lpn_id, lpn3.license_plate_number ,
531: inv_item_inq.get_status_code(msub.status_id),
532: inv_item_inq.get_status_code(milk.status_id),
533: inv_item_inq.get_status_code(mln.status_id),
534: lpn.lpn_context,
535: to_char(NULL), --Dock Door segs
536: msiv.serial_number_control_code,
537: TO_CHAR(NULL), --Project Number

Line 599: inv_item_inq.get_status_code(msub.status_id) ,

595: wlc.lot_number, wlc.serial_number,
596: wlc.quantity, wlc.uom_code,
597: nvl(wlc.cost_group_id, 0), ccg.cost_group,
598: lpn.outermost_lpn_id, lpn3.license_plate_number ,
599: inv_item_inq.get_status_code(msub.status_id) ,
600: inv_item_inq.get_status_code(milk.status_id) ,
601: inv_item_inq.get_status_code(mln.status_id) ,
602: lpn.lpn_context,
603: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id) ,

Line 600: inv_item_inq.get_status_code(milk.status_id) ,

596: wlc.quantity, wlc.uom_code,
597: nvl(wlc.cost_group_id, 0), ccg.cost_group,
598: lpn.outermost_lpn_id, lpn3.license_plate_number ,
599: inv_item_inq.get_status_code(msub.status_id) ,
600: inv_item_inq.get_status_code(milk.status_id) ,
601: inv_item_inq.get_status_code(mln.status_id) ,
602: lpn.lpn_context,
603: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id) ,
604: msiv.serial_number_control_code,

Line 601: inv_item_inq.get_status_code(mln.status_id) ,

597: nvl(wlc.cost_group_id, 0), ccg.cost_group,
598: lpn.outermost_lpn_id, lpn3.license_plate_number ,
599: inv_item_inq.get_status_code(msub.status_id) ,
600: inv_item_inq.get_status_code(milk.status_id) ,
601: inv_item_inq.get_status_code(mln.status_id) ,
602: lpn.lpn_context,
603: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id) ,
604: msiv.serial_number_control_code,
605: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_id),

Line 743: inv_item_inq.get_status_code(msub.status_id) ,

739: wwlc.primary_quantity,
740: msiv.primary_uom_code,
741: nvl(wwlc.cost_group_id, 0), ccg.cost_group,
742: lpn.outermost_lpn_id, lpn3.license_plate_number ,
743: inv_item_inq.get_status_code(msub.status_id) ,
744: inv_item_inq.get_status_code(milk.status_id) ,
745: inv_item_inq.get_status_code(mln.status_id) ,
746: lpn.lpn_context,
747: NULL, --dock door

Line 744: inv_item_inq.get_status_code(milk.status_id) ,

740: msiv.primary_uom_code,
741: nvl(wwlc.cost_group_id, 0), ccg.cost_group,
742: lpn.outermost_lpn_id, lpn3.license_plate_number ,
743: inv_item_inq.get_status_code(msub.status_id) ,
744: inv_item_inq.get_status_code(milk.status_id) ,
745: inv_item_inq.get_status_code(mln.status_id) ,
746: lpn.lpn_context,
747: NULL, --dock door
748: msiv.serial_number_control_code,

Line 745: inv_item_inq.get_status_code(mln.status_id) ,

741: nvl(wwlc.cost_group_id, 0), ccg.cost_group,
742: lpn.outermost_lpn_id, lpn3.license_plate_number ,
743: inv_item_inq.get_status_code(msub.status_id) ,
744: inv_item_inq.get_status_code(milk.status_id) ,
745: inv_item_inq.get_status_code(mln.status_id) ,
746: lpn.lpn_context,
747: NULL, --dock door
748: msiv.serial_number_control_code,
749: INV_PROJECT.GET_PROJECT_NUMBER, --project number

Line 846: inv_item_inq.get_status_code(msub.status_id) ,

842: --wlc.uom_code,
843: msiv.primary_uom_code,
844: nvl(wlc.cost_group_id, 0), ccg.cost_group,
845: lpn.outermost_lpn_id, lpn3.license_plate_number ,
846: inv_item_inq.get_status_code(msub.status_id) ,
847: inv_item_inq.get_status_code(milk.status_id) ,
848: inv_item_inq.get_status_code(mln.status_id) ,
849: lpn.lpn_context,
850: NULL, --dock door

Line 847: inv_item_inq.get_status_code(milk.status_id) ,

843: msiv.primary_uom_code,
844: nvl(wlc.cost_group_id, 0), ccg.cost_group,
845: lpn.outermost_lpn_id, lpn3.license_plate_number ,
846: inv_item_inq.get_status_code(msub.status_id) ,
847: inv_item_inq.get_status_code(milk.status_id) ,
848: inv_item_inq.get_status_code(mln.status_id) ,
849: lpn.lpn_context,
850: NULL, --dock door
851: msiv.serial_number_control_code,

Line 848: inv_item_inq.get_status_code(mln.status_id) ,

844: nvl(wlc.cost_group_id, 0), ccg.cost_group,
845: lpn.outermost_lpn_id, lpn3.license_plate_number ,
846: inv_item_inq.get_status_code(msub.status_id) ,
847: inv_item_inq.get_status_code(milk.status_id) ,
848: inv_item_inq.get_status_code(mln.status_id) ,
849: lpn.lpn_context,
850: NULL, --dock door
851: msiv.serial_number_control_code,
852: INV_PROJECT.GET_PROJECT_NUMBER, --project number

Line 962: , inv_item_inq.get_status_code(msub.status_id)

958: , nvl(wlc.cost_group_id, 0)
959: , ccg.cost_group
960: , lpn.outermost_lpn_id
961: , lpn3.license_plate_number
962: , inv_item_inq.get_status_code(msub.status_id)
963: , inv_item_inq.get_status_code(mlc.status_id)
964: , inv_item_inq.get_status_code(mln.status_id)
965: , lpn.gross_weight
966: , lpn.gross_weight_uom_code

Line 963: , inv_item_inq.get_status_code(mlc.status_id)

959: , ccg.cost_group
960: , lpn.outermost_lpn_id
961: , lpn3.license_plate_number
962: , inv_item_inq.get_status_code(msub.status_id)
963: , inv_item_inq.get_status_code(mlc.status_id)
964: , inv_item_inq.get_status_code(mln.status_id)
965: , lpn.gross_weight
966: , lpn.gross_weight_uom_code
967: , lpn.content_volume

Line 964: , inv_item_inq.get_status_code(mln.status_id)

960: , lpn.outermost_lpn_id
961: , lpn3.license_plate_number
962: , inv_item_inq.get_status_code(msub.status_id)
963: , inv_item_inq.get_status_code(mlc.status_id)
964: , inv_item_inq.get_status_code(mln.status_id)
965: , lpn.gross_weight
966: , lpn.gross_weight_uom_code
967: , lpn.content_volume
968: , lpn.content_volume_uom_code

Line 2012: PROCEDURE INV_ITEM_INQUIRIES (

2008: * Overloaded to include filtering on project and task
2009: ******************************************************
2010: */
2011:
2012: PROCEDURE INV_ITEM_INQUIRIES (
2013: x_item_inquiries OUT NOCOPY t_genref,
2014: p_Organization_Id IN NUMBER,
2015: p_Inventory_Item_Id IN NUMBER DEFAULT NULL,
2016: p_Revision IN VARCHAR2 DEFAULT NULL,

Line 2039: /*inv_ITEM_INQ.get_available_qty(

2035: sum(nvl(moq.primary_transaction_quantity, 0)),
2036: /* Bug 4117556 performance issue for item inquiry
2037: Do not call quantity tree to get available quantity for each onhand record
2038: Instead, calling quantity tree at each page entered event of ItemOnhandPage */
2039: /*inv_ITEM_INQ.get_available_qty(
2040: moq.organization_id,
2041: moq.inventory_item_id,
2042: moq.revision,
2043: moq.subinventory_code,

Line 2051: inv_item_inq.get_status_code(msub.status_id),

2047: decode(msik.lot_control_code, 2, 'TRUE', 'FALSE'),
2048: decode(msik.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE'))*/
2049: -999,
2050: msub.status_id,
2051: inv_item_inq.get_status_code(msub.status_id),
2052: mil.status_id,
2053: inv_item_inq.get_status_code(mil.status_id),
2054: mln.status_id,
2055: inv_item_inq.get_status_code(mln.status_id),

Line 2053: inv_item_inq.get_status_code(mil.status_id),

2049: -999,
2050: msub.status_id,
2051: inv_item_inq.get_status_code(msub.status_id),
2052: mil.status_id,
2053: inv_item_inq.get_status_code(mil.status_id),
2054: mln.status_id,
2055: inv_item_inq.get_status_code(mln.status_id),
2056: msik.serial_number_control_code,
2057: moq.cost_group_id,

Line 2055: inv_item_inq.get_status_code(mln.status_id),

2051: inv_item_inq.get_status_code(msub.status_id),
2052: mil.status_id,
2053: inv_item_inq.get_status_code(mil.status_id),
2054: mln.status_id,
2055: inv_item_inq.get_status_code(mln.status_id),
2056: msik.serial_number_control_code,
2057: moq.cost_group_id,
2058: INV_PROJECT.GET_PROJECT_NUMBER project_number, --Project #
2059: INV_PROJECT.GET_TASK_NUMBER task_number, --Task #

Line 2101: /*inv_item_inq.get_available_qty(

2097: moq.subinventory_code, moq.locator_id,
2098: INV_PROJECT.GET_LOCSEGS(moq.locator_id,p_organization_id),
2099: moq.lot_number, msik.primary_uom_code,
2100: /* Bug 4117556 performance issue for item inquiry */
2101: /*inv_item_inq.get_available_qty(
2102: moq.organization_id,
2103: moq.inventory_item_id,
2104: moq.revision,
2105: moq.subinventory_code,

Line 2113: inv_item_inq.get_status_code(msub.status_id),

2109: decode(msik.lot_control_code, 2, 'TRUE', 'FALSE'),
2110: decode(msik.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE'))*/
2111: -999,
2112: msub.status_id,
2113: inv_item_inq.get_status_code(msub.status_id),
2114: mil.status_id,
2115: inv_item_inq.get_status_code(mil.status_id),
2116: mln.status_id,
2117: inv_item_inq.get_status_code(mln.status_id),

Line 2115: inv_item_inq.get_status_code(mil.status_id),

2111: -999,
2112: msub.status_id,
2113: inv_item_inq.get_status_code(msub.status_id),
2114: mil.status_id,
2115: inv_item_inq.get_status_code(mil.status_id),
2116: mln.status_id,
2117: inv_item_inq.get_status_code(mln.status_id),
2118: msik.serial_number_control_code,
2119: moq.cost_group_id,

Line 2117: inv_item_inq.get_status_code(mln.status_id),

2113: inv_item_inq.get_status_code(msub.status_id),
2114: mil.status_id,
2115: inv_item_inq.get_status_code(mil.status_id),
2116: mln.status_id,
2117: inv_item_inq.get_status_code(mln.status_id),
2118: msik.serial_number_control_code,
2119: moq.cost_group_id,
2120: INV_PROJECT.GET_PROJECT_NUMBER,
2121: INV_PROJECT.GET_TASK_NUMBER,

Line 2134: END INV_ITEM_INQUIRIES;

2130: EXCEPTION
2131: when others then
2132: x_status := 'E';
2133: x_message := substr(SQLERRM,1,240);
2134: END INV_ITEM_INQUIRIES;
2135:
2136: /*******************************************************************
2137: * Obtain onhand information WMS org, provide cost group
2138: * information query wms related information

Line 2177: /*inv_item_inq.get_available_qty(

2173: b.sum_txn_qty,
2174: /* Bug 4117556 performance issue for item inquiry
2175: Do not call quantity tree to get available quantity for each onhand record
2176: Instead, calling quantity tree at each page entered event of ItemOnhandPage */
2177: /*inv_item_inq.get_available_qty(
2178: b.organization_id,
2179: b.inventory_item_id,
2180: b.revision,
2181: b.subinventory_code,

Line 2190: ---inv_item_inq.get_packed_quantity(

2186: decode(b.lot_control_code, 2, 'TRUE', 'FALSE'),
2187: decode(b.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE'))*/
2188: -999,
2189: -- INVCONV start
2190: ---inv_item_inq.get_packed_quantity(
2191: --- b.organization_id, b.inventory_item_id, b.revision,
2192: --- b.subinventory_code, b.locator_id, b.lot_number, b.cost_Group_id),
2193: ---inv_item_inq.get_loose_quantity(
2194: --- b.organization_id, b.inventory_item_id, b.revision,

Line 2193: ---inv_item_inq.get_loose_quantity(

2189: -- INVCONV start
2190: ---inv_item_inq.get_packed_quantity(
2191: --- b.organization_id, b.inventory_item_id, b.revision,
2192: --- b.subinventory_code, b.locator_id, b.lot_number, b.cost_Group_id),
2193: ---inv_item_inq.get_loose_quantity(
2194: --- b.organization_id, b.inventory_item_id, b.revision,
2195: --- b.subinventory_code, b.locator_id, b.lot_number, b.cost_Group_id),
2196: b.packed_quantity, -- Bug : 4563072
2197: b.loose_quantity, -- Bug : 4563072

Line 2585: inv_item_inq.get_status_code(msub.status_id) sub_status,

2581: p_organization_id) concatenated_segments, --Locator Segments
2582: msn.lot_number,
2583: msik.primary_uom_code,
2584: count(msn.serial_number) total_qty,
2585: inv_item_inq.get_status_code(msub.status_id) sub_status,
2586: inv_item_inq.get_status_code(milk.status_id) loc_status,
2587: inv_item_inq.get_status_code(mln.status_id) lot_status,
2588: msik.serial_number_control_code,
2589: msn.cost_group_id,

Line 2586: inv_item_inq.get_status_code(milk.status_id) loc_status,

2582: msn.lot_number,
2583: msik.primary_uom_code,
2584: count(msn.serial_number) total_qty,
2585: inv_item_inq.get_status_code(msub.status_id) sub_status,
2586: inv_item_inq.get_status_code(milk.status_id) loc_status,
2587: inv_item_inq.get_status_code(mln.status_id) lot_status,
2588: msik.serial_number_control_code,
2589: msn.cost_group_id,
2590: INV_PROJECT.GET_PROJECT_NUMBER project_number,

Line 2587: inv_item_inq.get_status_code(mln.status_id) lot_status,

2583: msik.primary_uom_code,
2584: count(msn.serial_number) total_qty,
2585: inv_item_inq.get_status_code(msub.status_id) sub_status,
2586: inv_item_inq.get_status_code(milk.status_id) loc_status,
2587: inv_item_inq.get_status_code(mln.status_id) lot_status,
2588: msik.serial_number_control_code,
2589: msn.cost_group_id,
2590: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2591: INV_PROJECT.GET_TASK_NUMBER task_number

Line 2633: inv_item_inq.get_status_code(msub.status_id),

2629: msn.current_locator_id,
2630: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,p_organization_id),
2631: msn.lot_number,
2632: msik.primary_uom_code,
2633: inv_item_inq.get_status_code(msub.status_id),
2634: inv_item_inq.get_status_code(milk.status_id),
2635: inv_item_inq.get_status_code(mln.status_id),
2636: msik.serial_number_control_code,
2637: msn.cost_group_id,

Line 2634: inv_item_inq.get_status_code(milk.status_id),

2630: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,p_organization_id),
2631: msn.lot_number,
2632: msik.primary_uom_code,
2633: inv_item_inq.get_status_code(msub.status_id),
2634: inv_item_inq.get_status_code(milk.status_id),
2635: inv_item_inq.get_status_code(mln.status_id),
2636: msik.serial_number_control_code,
2637: msn.cost_group_id,
2638: INV_PROJECT.GET_PROJECT_NUMBER,

Line 2635: inv_item_inq.get_status_code(mln.status_id),

2631: msn.lot_number,
2632: msik.primary_uom_code,
2633: inv_item_inq.get_status_code(msub.status_id),
2634: inv_item_inq.get_status_code(milk.status_id),
2635: inv_item_inq.get_status_code(mln.status_id),
2636: msik.serial_number_control_code,
2637: msn.cost_group_id,
2638: INV_PROJECT.GET_PROJECT_NUMBER,
2639: INV_PROJECT.GET_TASK_NUMBER;

Line 2822: inv_item_inq.get_available_qty(

2818: NULL,--b.lot_status_id,
2819: NULL,--b.lot_status,
2820: b.primary_uom_code,
2821: b.sum_txn_qty,
2822: inv_item_inq.get_available_qty(
2823: b.organization_id,
2824: b.inventory_item_id,
2825: NULL,--b.revision,
2826: b.subinventory_code,

Line 2833: inv_item_inq.get_packed_quantity(

2829: NULL,--b.cost_group_id
2830: 'FALSE',
2831: decode(b.lot_control_code, 2, 'TRUE', 'FALSE'),
2832: decode(b.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE')) ,
2833: inv_item_inq.get_packed_quantity(
2834: b.organization_id,
2835: b.inventory_item_id,
2836: NULL,--b.revision,
2837: b.subinventory_code,

Line 2842: inv_item_inq.get_loose_quantity(

2838: b.locator_id,
2839: NULL,--b.lot_number,
2840: NULL--b.cost_Group_id
2841: ) ,
2842: inv_item_inq.get_loose_quantity(
2843: b.organization_id,
2844: b.inventory_item_id,
2845: NULL,--b.revision,
2846: b.subinventory_code,

Line 2926: END inv_ITEM_INQ;

2922:
2923:
2924:
2925:
2926: END inv_ITEM_INQ;