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.17 2011/12/10 11:59:53 ssrikaku ship $ */
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 529: inv_item_inq.get_status_code(msub.status_id),

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

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

526: ccg.cost_group,
527: lpn.outermost_lpn_id,
528: lpn3.license_plate_number ,
529: inv_item_inq.get_status_code(msub.status_id),
530: inv_item_inq.get_status_code(milk.status_id),
531: to_char(NULL), --Lot Status
532: lpn.lpn_context,
533: to_char(NULL), --Dock Door segs
534: msiv.serial_number_control_code,

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

565: mmtt.transaction_uom,
566: nvl(mmtt.cost_group_id, 0),
567: ccg.cost_group,
568: lpn.outermost_lpn_id, lpn3.license_plate_number ,
569: inv_item_inq.get_status_code(msub.status_id),
570: inv_item_inq.get_status_code(milk.status_id),
571: inv_item_inq.get_status_code(mln.status_id),
572: lpn.lpn_context,
573: to_char(NULL), --Dock Door segs

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

566: nvl(mmtt.cost_group_id, 0),
567: ccg.cost_group,
568: lpn.outermost_lpn_id, lpn3.license_plate_number ,
569: inv_item_inq.get_status_code(msub.status_id),
570: inv_item_inq.get_status_code(milk.status_id),
571: inv_item_inq.get_status_code(mln.status_id),
572: lpn.lpn_context,
573: to_char(NULL), --Dock Door segs
574: msiv.serial_number_control_code,

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

567: ccg.cost_group,
568: lpn.outermost_lpn_id, lpn3.license_plate_number ,
569: inv_item_inq.get_status_code(msub.status_id),
570: inv_item_inq.get_status_code(milk.status_id),
571: inv_item_inq.get_status_code(mln.status_id),
572: lpn.lpn_context,
573: to_char(NULL), --Dock Door segs
574: msiv.serial_number_control_code,
575: TO_CHAR(NULL), --Project Number

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

637: mmtt.transaction_uom,
638: nvl(mmtt.cost_group_id, 0),
639: ccg.cost_group,
640: lpn.outermost_lpn_id, lpn3.license_plate_number ,
641: inv_item_inq.get_status_code(msub.status_id),
642: inv_item_inq.get_status_code(milk.status_id),
643: inv_item_inq.get_status_code(mln.status_id),
644: lpn.lpn_context,
645: to_char(NULL), --Dock Door segs

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

638: nvl(mmtt.cost_group_id, 0),
639: ccg.cost_group,
640: lpn.outermost_lpn_id, lpn3.license_plate_number ,
641: inv_item_inq.get_status_code(msub.status_id),
642: inv_item_inq.get_status_code(milk.status_id),
643: inv_item_inq.get_status_code(mln.status_id),
644: lpn.lpn_context,
645: to_char(NULL), --Dock Door segs
646: msiv.serial_number_control_code,

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

639: ccg.cost_group,
640: lpn.outermost_lpn_id, lpn3.license_plate_number ,
641: inv_item_inq.get_status_code(msub.status_id),
642: inv_item_inq.get_status_code(milk.status_id),
643: inv_item_inq.get_status_code(mln.status_id),
644: lpn.lpn_context,
645: to_char(NULL), --Dock Door segs
646: msiv.serial_number_control_code,
647: TO_CHAR(NULL), --Project Number

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

671: wlc.lot_number, wlc.serial_number,
672: wlc.quantity, wlc.uom_code,
673: nvl(wlc.cost_group_id, 0), ccg.cost_group,
674: lpn.outermost_lpn_id, lpn3.license_plate_number ,
675: inv_item_inq.get_status_code(msub.status_id) ,
676: inv_item_inq.get_status_code(milk.status_id) ,
677: inv_item_inq.get_status_code(mln.status_id) ,
678: lpn.lpn_context,
679: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id) ,

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

672: wlc.quantity, wlc.uom_code,
673: nvl(wlc.cost_group_id, 0), ccg.cost_group,
674: lpn.outermost_lpn_id, lpn3.license_plate_number ,
675: inv_item_inq.get_status_code(msub.status_id) ,
676: inv_item_inq.get_status_code(milk.status_id) ,
677: inv_item_inq.get_status_code(mln.status_id) ,
678: lpn.lpn_context,
679: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id) ,
680: msiv.serial_number_control_code,

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

673: nvl(wlc.cost_group_id, 0), ccg.cost_group,
674: lpn.outermost_lpn_id, lpn3.license_plate_number ,
675: inv_item_inq.get_status_code(msub.status_id) ,
676: inv_item_inq.get_status_code(milk.status_id) ,
677: inv_item_inq.get_status_code(mln.status_id) ,
678: lpn.lpn_context,
679: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id) ,
680: msiv.serial_number_control_code,
681: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_id),

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

815: wwlc.primary_quantity,
816: msiv.primary_uom_code,
817: nvl(wwlc.cost_group_id, 0), ccg.cost_group,
818: lpn.outermost_lpn_id, lpn3.license_plate_number ,
819: inv_item_inq.get_status_code(msub.status_id) ,
820: inv_item_inq.get_status_code(milk.status_id) ,
821: inv_item_inq.get_status_code(mln.status_id) ,
822: lpn.lpn_context,
823: NULL, --dock door

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

816: msiv.primary_uom_code,
817: nvl(wwlc.cost_group_id, 0), ccg.cost_group,
818: lpn.outermost_lpn_id, lpn3.license_plate_number ,
819: inv_item_inq.get_status_code(msub.status_id) ,
820: inv_item_inq.get_status_code(milk.status_id) ,
821: inv_item_inq.get_status_code(mln.status_id) ,
822: lpn.lpn_context,
823: NULL, --dock door
824: msiv.serial_number_control_code,

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

817: nvl(wwlc.cost_group_id, 0), ccg.cost_group,
818: lpn.outermost_lpn_id, lpn3.license_plate_number ,
819: inv_item_inq.get_status_code(msub.status_id) ,
820: inv_item_inq.get_status_code(milk.status_id) ,
821: inv_item_inq.get_status_code(mln.status_id) ,
822: lpn.lpn_context,
823: NULL, --dock door
824: msiv.serial_number_control_code,
825: INV_PROJECT.GET_PROJECT_NUMBER, --project number

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

918: --wlc.uom_code,
919: msiv.primary_uom_code,
920: nvl(wlc.cost_group_id, 0), ccg.cost_group,
921: lpn.outermost_lpn_id, lpn3.license_plate_number ,
922: inv_item_inq.get_status_code(msub.status_id) ,
923: inv_item_inq.get_status_code(milk.status_id) ,
924: inv_item_inq.get_status_code(mln.status_id) ,
925: lpn.lpn_context,
926: NULL, --dock door

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

919: msiv.primary_uom_code,
920: nvl(wlc.cost_group_id, 0), ccg.cost_group,
921: lpn.outermost_lpn_id, lpn3.license_plate_number ,
922: inv_item_inq.get_status_code(msub.status_id) ,
923: inv_item_inq.get_status_code(milk.status_id) ,
924: inv_item_inq.get_status_code(mln.status_id) ,
925: lpn.lpn_context,
926: NULL, --dock door
927: msiv.serial_number_control_code,

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

920: nvl(wlc.cost_group_id, 0), ccg.cost_group,
921: lpn.outermost_lpn_id, lpn3.license_plate_number ,
922: inv_item_inq.get_status_code(msub.status_id) ,
923: inv_item_inq.get_status_code(milk.status_id) ,
924: inv_item_inq.get_status_code(mln.status_id) ,
925: lpn.lpn_context,
926: NULL, --dock door
927: msiv.serial_number_control_code,
928: INV_PROJECT.GET_PROJECT_NUMBER, --project number

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

1034: , nvl(wlc.cost_group_id, 0)
1035: , ccg.cost_group
1036: , lpn.outermost_lpn_id
1037: , lpn3.license_plate_number
1038: , inv_item_inq.get_status_code(msub.status_id)
1039: , inv_item_inq.get_status_code(mlc.status_id)
1040: , inv_item_inq.get_status_code(mln.status_id)
1041: , lpn.gross_weight
1042: , lpn.gross_weight_uom_code

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

1035: , ccg.cost_group
1036: , lpn.outermost_lpn_id
1037: , lpn3.license_plate_number
1038: , inv_item_inq.get_status_code(msub.status_id)
1039: , inv_item_inq.get_status_code(mlc.status_id)
1040: , inv_item_inq.get_status_code(mln.status_id)
1041: , lpn.gross_weight
1042: , lpn.gross_weight_uom_code
1043: , lpn.content_volume

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

1036: , lpn.outermost_lpn_id
1037: , lpn3.license_plate_number
1038: , inv_item_inq.get_status_code(msub.status_id)
1039: , inv_item_inq.get_status_code(mlc.status_id)
1040: , inv_item_inq.get_status_code(mln.status_id)
1041: , lpn.gross_weight
1042: , lpn.gross_weight_uom_code
1043: , lpn.content_volume
1044: , lpn.content_volume_uom_code

Line 2088: PROCEDURE INV_ITEM_INQUIRIES (

2084: * Overloaded to include filtering on project and task
2085: ******************************************************
2086: */
2087:
2088: PROCEDURE INV_ITEM_INQUIRIES (
2089: x_item_inquiries OUT NOCOPY t_genref,
2090: p_Organization_Id IN NUMBER,
2091: p_Inventory_Item_Id IN NUMBER DEFAULT NULL,
2092: p_Revision IN VARCHAR2 DEFAULT NULL,

Line 2115: /*inv_ITEM_INQ.get_available_qty(

2111: sum(nvl(moq.primary_transaction_quantity, 0)),
2112: /* Bug 4117556 performance issue for item inquiry
2113: Do not call quantity tree to get available quantity for each onhand record
2114: Instead, calling quantity tree at each page entered event of ItemOnhandPage */
2115: /*inv_ITEM_INQ.get_available_qty(
2116: moq.organization_id,
2117: moq.inventory_item_id,
2118: moq.revision,
2119: moq.subinventory_code,

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

2123: decode(msik.lot_control_code, 2, 'TRUE', 'FALSE'),
2124: decode(msik.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE'))*/
2125: -999,
2126: msub.status_id,
2127: inv_item_inq.get_status_code(msub.status_id),
2128: mil.status_id,
2129: inv_item_inq.get_status_code(mil.status_id),
2130: mln.status_id,
2131: inv_item_inq.get_status_code(mln.status_id),

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

2125: -999,
2126: msub.status_id,
2127: inv_item_inq.get_status_code(msub.status_id),
2128: mil.status_id,
2129: inv_item_inq.get_status_code(mil.status_id),
2130: mln.status_id,
2131: inv_item_inq.get_status_code(mln.status_id),
2132: msik.serial_number_control_code,
2133: moq.cost_group_id,

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

2127: inv_item_inq.get_status_code(msub.status_id),
2128: mil.status_id,
2129: inv_item_inq.get_status_code(mil.status_id),
2130: mln.status_id,
2131: inv_item_inq.get_status_code(mln.status_id),
2132: msik.serial_number_control_code,
2133: moq.cost_group_id,
2134: INV_PROJECT.GET_PROJECT_NUMBER project_number, --Project #
2135: INV_PROJECT.GET_TASK_NUMBER task_number, --Task #

Line 2177: /*inv_item_inq.get_available_qty(

2173: moq.subinventory_code, moq.locator_id,
2174: INV_PROJECT.GET_LOCSEGS(moq.locator_id,p_organization_id),
2175: moq.lot_number, msik.primary_uom_code,
2176: /* Bug 4117556 performance issue for item inquiry */
2177: /*inv_item_inq.get_available_qty(
2178: moq.organization_id,
2179: moq.inventory_item_id,
2180: moq.revision,
2181: moq.subinventory_code,

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

2185: decode(msik.lot_control_code, 2, 'TRUE', 'FALSE'),
2186: decode(msik.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE'))*/
2187: -999,
2188: msub.status_id,
2189: inv_item_inq.get_status_code(msub.status_id),
2190: mil.status_id,
2191: inv_item_inq.get_status_code(mil.status_id),
2192: mln.status_id,
2193: inv_item_inq.get_status_code(mln.status_id),

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

2187: -999,
2188: msub.status_id,
2189: inv_item_inq.get_status_code(msub.status_id),
2190: mil.status_id,
2191: inv_item_inq.get_status_code(mil.status_id),
2192: mln.status_id,
2193: inv_item_inq.get_status_code(mln.status_id),
2194: msik.serial_number_control_code,
2195: moq.cost_group_id,

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

2189: inv_item_inq.get_status_code(msub.status_id),
2190: mil.status_id,
2191: inv_item_inq.get_status_code(mil.status_id),
2192: mln.status_id,
2193: inv_item_inq.get_status_code(mln.status_id),
2194: msik.serial_number_control_code,
2195: moq.cost_group_id,
2196: INV_PROJECT.GET_PROJECT_NUMBER,
2197: INV_PROJECT.GET_TASK_NUMBER,

Line 2210: END INV_ITEM_INQUIRIES;

2206: EXCEPTION
2207: when others then
2208: x_status := 'E';
2209: x_message := substr(SQLERRM,1,240);
2210: END INV_ITEM_INQUIRIES;
2211:
2212: /*******************************************************************
2213: * Obtain onhand information WMS org, provide cost group
2214: * information query wms related information

Line 2253: /*inv_item_inq.get_available_qty(

2249: b.sum_txn_qty,
2250: /* Bug 4117556 performance issue for item inquiry
2251: Do not call quantity tree to get available quantity for each onhand record
2252: Instead, calling quantity tree at each page entered event of ItemOnhandPage */
2253: /*inv_item_inq.get_available_qty(
2254: b.organization_id,
2255: b.inventory_item_id,
2256: b.revision,
2257: b.subinventory_code,

Line 2266: ---inv_item_inq.get_packed_quantity(

2262: decode(b.lot_control_code, 2, 'TRUE', 'FALSE'),
2263: decode(b.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE'))*/
2264: -999,
2265: -- INVCONV start
2266: ---inv_item_inq.get_packed_quantity(
2267: --- b.organization_id, b.inventory_item_id, b.revision,
2268: --- b.subinventory_code, b.locator_id, b.lot_number, b.cost_Group_id),
2269: ---inv_item_inq.get_loose_quantity(
2270: --- b.organization_id, b.inventory_item_id, b.revision,

Line 2269: ---inv_item_inq.get_loose_quantity(

2265: -- INVCONV start
2266: ---inv_item_inq.get_packed_quantity(
2267: --- b.organization_id, b.inventory_item_id, b.revision,
2268: --- b.subinventory_code, b.locator_id, b.lot_number, b.cost_Group_id),
2269: ---inv_item_inq.get_loose_quantity(
2270: --- b.organization_id, b.inventory_item_id, b.revision,
2271: --- b.subinventory_code, b.locator_id, b.lot_number, b.cost_Group_id),
2272: b.packed_quantity, -- Bug : 4563072
2273: b.loose_quantity, -- Bug : 4563072

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

2677: p_organization_id) concatenated_segments, --Locator Segments
2678: msn.lot_number,
2679: msik.primary_uom_code,
2680: count(msn.serial_number) total_qty,
2681: inv_item_inq.get_status_code(msub.status_id) sub_status,
2682: inv_item_inq.get_status_code(milk.status_id) loc_status,
2683: inv_item_inq.get_status_code(mln.status_id) lot_status,
2684: msik.serial_number_control_code,
2685: msn.cost_group_id,

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

2678: msn.lot_number,
2679: msik.primary_uom_code,
2680: count(msn.serial_number) total_qty,
2681: inv_item_inq.get_status_code(msub.status_id) sub_status,
2682: inv_item_inq.get_status_code(milk.status_id) loc_status,
2683: inv_item_inq.get_status_code(mln.status_id) lot_status,
2684: msik.serial_number_control_code,
2685: msn.cost_group_id,
2686: INV_PROJECT.GET_PROJECT_NUMBER project_number,

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

2679: msik.primary_uom_code,
2680: count(msn.serial_number) total_qty,
2681: inv_item_inq.get_status_code(msub.status_id) sub_status,
2682: inv_item_inq.get_status_code(milk.status_id) loc_status,
2683: inv_item_inq.get_status_code(mln.status_id) lot_status,
2684: msik.serial_number_control_code,
2685: msn.cost_group_id,
2686: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2687: INV_PROJECT.GET_TASK_NUMBER task_number

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

2725: msn.current_locator_id,
2726: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,p_organization_id),
2727: msn.lot_number,
2728: msik.primary_uom_code,
2729: inv_item_inq.get_status_code(msub.status_id),
2730: inv_item_inq.get_status_code(milk.status_id),
2731: inv_item_inq.get_status_code(mln.status_id),
2732: msik.serial_number_control_code,
2733: msn.cost_group_id,

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

2726: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,p_organization_id),
2727: msn.lot_number,
2728: msik.primary_uom_code,
2729: inv_item_inq.get_status_code(msub.status_id),
2730: inv_item_inq.get_status_code(milk.status_id),
2731: inv_item_inq.get_status_code(mln.status_id),
2732: msik.serial_number_control_code,
2733: msn.cost_group_id,
2734: INV_PROJECT.GET_PROJECT_NUMBER,

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

2727: msn.lot_number,
2728: msik.primary_uom_code,
2729: inv_item_inq.get_status_code(msub.status_id),
2730: inv_item_inq.get_status_code(milk.status_id),
2731: inv_item_inq.get_status_code(mln.status_id),
2732: msik.serial_number_control_code,
2733: msn.cost_group_id,
2734: INV_PROJECT.GET_PROJECT_NUMBER,
2735: INV_PROJECT.GET_TASK_NUMBER;

Line 2918: inv_item_inq.get_available_qty(

2914: NULL,--b.lot_status_id,
2915: NULL,--b.lot_status,
2916: b.primary_uom_code,
2917: b.sum_txn_qty,
2918: inv_item_inq.get_available_qty(
2919: b.organization_id,
2920: b.inventory_item_id,
2921: NULL,--b.revision,
2922: b.subinventory_code,

Line 2929: inv_item_inq.get_packed_quantity(

2925: NULL,--b.cost_group_id
2926: 'FALSE',
2927: decode(b.lot_control_code, 2, 'TRUE', 'FALSE'),
2928: decode(b.serial_number_control_code, NULL, 'FALSE', 1, 'FALSE', 'TRUE')) ,
2929: inv_item_inq.get_packed_quantity(
2930: b.organization_id,
2931: b.inventory_item_id,
2932: NULL,--b.revision,
2933: b.subinventory_code,

Line 2938: inv_item_inq.get_loose_quantity(

2934: b.locator_id,
2935: NULL,--b.lot_number,
2936: NULL--b.cost_Group_id
2937: ) ,
2938: inv_item_inq.get_loose_quantity(
2939: b.organization_id,
2940: b.inventory_item_id,
2941: NULL,--b.revision,
2942: b.subinventory_code,

Line 3038: END inv_ITEM_INQ;

3034:
3035:
3036:
3037:
3038: END inv_ITEM_INQ;