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_PROJECT

Line 454: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,

450: mp.organization_code ,
451: mmtt.revision,
452: mmtt.subinventory_code ,
453: mmtt.locator_id,
454: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,
455: to_char(NULL) lot_number,
456: to_char(NULL) serial_number,
457: mmtt.transaction_quantity,
458: mmtt.transaction_uom,

Line 469: INV_PROJECT.GET_PROJECT_NUMBER, --Project Number

465: to_char(NULL), --Lot Status
466: lpn.lpn_context,
467: to_char(NULL), --Dock Door segs
468: msiv.serial_number_control_code,
469: INV_PROJECT.GET_PROJECT_NUMBER, --Project Number
470: INV_PROJECT.GET_TASK_NUMBER, --Task Number
471: to_char(NULL), --Source Name
472: -- INVCONV start
473: NVL(msiv.tracking_quantity_ind, 'P'),

Line 470: INV_PROJECT.GET_TASK_NUMBER, --Task Number

466: lpn.lpn_context,
467: to_char(NULL), --Dock Door segs
468: msiv.serial_number_control_code,
469: INV_PROJECT.GET_PROJECT_NUMBER, --Project Number
470: INV_PROJECT.GET_TASK_NUMBER, --Task Number
471: to_char(NULL), --Source Name
472: -- INVCONV start
473: NVL(msiv.tracking_quantity_ind, 'P'),
474: msiv.secondary_uom_code,

Line 523: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id, mlc.organization_id),

519: mp.organization_code ,
520: mmtt.revision,
521: mmtt.subinventory_code ,
522: mmtt.locator_id,
523: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id, mlc.organization_id),
524: mtlt.lot_number,
525: to_char(NULL) serial_number,
526: mtLt.transaction_quantity, --Get qty for each lot
527: mmtt.transaction_uom,

Line 594: lpn.locator_id, INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,

590: wlc.inventory_item_id, msiv.concatenated_segments, msiv.description,
591: wlc.organization_id , mp.organization_code ,
592: wlc.revision,
593: lpn.subinventory_code ,
594: lpn.locator_id, INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_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 ,

Line 603: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id) ,

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),
606: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
607: wlc.source_name,

Line 605: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_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),
606: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
607: wlc.source_name,
608: -- INVCONV start
609: NVL(msiv.tracking_quantity_ind, 'P'),

Line 606: INV_PROJECT.GET_TASK_NUMBER(mlc.task_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),
606: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
607: wlc.source_name,
608: -- INVCONV start
609: NVL(msiv.tracking_quantity_ind, 'P'),
610: msiv.secondary_uom_code,

Line 664: lpn.locator_id, INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id, mlc.organization_id),

660: 0, null, wlc.item_description,
661: wlc.organization_id , mp.organization_code ,
662: wlc.revision,
663: lpn.subinventory_code ,
664: lpn.locator_id, INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id, mlc.organization_id),
665: null, null,
666: wlc.quantity, wlc.uom_code,
667: nvl(wlc.cost_group_id, 0), ccg.cost_group,
668: lpn.outermost_lpn_id, lpn3.license_plate_number ,

Line 671: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id),

667: nvl(wlc.cost_group_id, 0), ccg.cost_group,
668: lpn.outermost_lpn_id, lpn3.license_plate_number ,
669: null, null, null,
670: lpn.lpn_context,
671: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id),
672: 0,
673: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_id),
674: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
675: wlc.source_name,

Line 673: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_id),

669: null, null, null,
670: lpn.lpn_context,
671: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id),
672: 0,
673: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_id),
674: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
675: wlc.source_name,
676: -- INVCONV start
677: 'P',

Line 674: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),

670: lpn.lpn_context,
671: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id),
672: 0,
673: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_id),
674: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
675: wlc.source_name,
676: -- INVCONV start
677: 'P',
678: NULL,

Line 734: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,

730: wwlc.organization_id , mp.organization_code ,
731: wwlc.revision,
732: lpn.subinventory_code ,
733: lpn.locator_id,
734: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,
735: wwlc.lot_number, wwlc.serial_number,
736: -- Release 12: change to sum of primary quantity
737: -- and select primary uom
738: -- sum(wlc.quantity), wlc.uom_code, /* 3372973 : Sum of quantity is taken as wlc is grouped */

Line 749: INV_PROJECT.GET_PROJECT_NUMBER, --project number

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
750: INV_PROJECT.GET_TASK_NUMBER, --task number
751: wwlc.source_name,
752: -- INVCONV start
753: NVL(msiv.tracking_quantity_ind, 'P'),

Line 750: INV_PROJECT.GET_TASK_NUMBER, --task number

746: lpn.lpn_context,
747: NULL, --dock door
748: msiv.serial_number_control_code,
749: INV_PROJECT.GET_PROJECT_NUMBER, --project number
750: INV_PROJECT.GET_TASK_NUMBER, --task number
751: wwlc.source_name,
752: -- INVCONV start
753: NVL(msiv.tracking_quantity_ind, 'P'),
754: msiv.secondary_uom_code,

Line 839: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,

835: wlc.organization_id , mp.organization_code ,
836: wlc.revision,
837: lpn.subinventory_code ,
838: lpn.locator_id,
839: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,
840: wlc.lot_number, wlc.serial_number,
841: --Release 12(K), group by primary UOM
842: --wlc.uom_code,
843: msiv.primary_uom_code,

Line 852: INV_PROJECT.GET_PROJECT_NUMBER, --project number

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
853: INV_PROJECT.GET_TASK_NUMBER, --task number
854: wlc.source_name,
855: -- INVCONV start
856: NVL(msiv.tracking_quantity_ind, 'P'),

Line 853: INV_PROJECT.GET_TASK_NUMBER, --task number

849: lpn.lpn_context,
850: NULL, --dock door
851: msiv.serial_number_control_code,
852: INV_PROJECT.GET_PROJECT_NUMBER, --project number
853: INV_PROJECT.GET_TASK_NUMBER, --task number
854: wlc.source_name,
855: -- INVCONV start
856: NVL(msiv.tracking_quantity_ind, 'P'),
857: msiv.secondary_uom_code

Line 870: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id, mlc.organization_id),

866: wlc.organization_id , mp.organization_code ,
867: wlc.revision,
868: lpn.subinventory_code ,
869: lpn.locator_id,
870: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id, mlc.organization_id),
871: null, null,
872: wlc.quantity, wlc.uom_code,
873: nvl(wlc.cost_group_id, 0), ccg.cost_group,
874: lpn.outermost_lpn_id, lpn3.license_plate_number ,

Line 879: INV_PROJECT.GET_PROJECT_NUMBER, --project number

875: null, null, null,
876: lpn.lpn_context,
877: NULL, --dock door
878: 0,
879: INV_PROJECT.GET_PROJECT_NUMBER, --project number
880: INV_PROJECT.GET_TASK_NUMBER, --task number
881: wlc.source_name,
882: -- INVCONV start
883: 'P',

Line 880: INV_PROJECT.GET_TASK_NUMBER, --task number

876: lpn.lpn_context,
877: NULL, --dock door
878: 0,
879: INV_PROJECT.GET_PROJECT_NUMBER, --project number
880: INV_PROJECT.GET_TASK_NUMBER, --task number
881: wlc.source_name,
882: -- INVCONV start
883: 'P',
884: NULL,

Line 953: , INV_PROJECT.GET_LOCSEGS(lpn.locator_id, lpn.organization_id) concatenated_segments

949: , wlc.revision
950: , lpn.subinventory_code
951: , lpn.locator_id
952: --, mlc.concatenated_segments
953: , INV_PROJECT.GET_LOCSEGS(lpn.locator_id, lpn.organization_id) concatenated_segments
954: , wlc.lot_number
955: , wlc.serial_number
956: , wlc.quantity
957: , wlc.uom_code

Line 970: , INV_PROJECT.GET_PROJECT_NUMBER project_number

966: , lpn.gross_weight_uom_code
967: , lpn.content_volume
968: , lpn.content_volume_uom_code
969: , msiv.serial_number_control_code
970: , INV_PROJECT.GET_PROJECT_NUMBER project_number
971: , INV_PROJECT.GET_TASK_NUMBER task_number
972: , wlc.source_name
973: -- INVCONV start
974: , NVL(msiv.tracking_quantity_ind, 'P')

Line 971: , INV_PROJECT.GET_TASK_NUMBER task_number

967: , lpn.content_volume
968: , lpn.content_volume_uom_code
969: , msiv.serial_number_control_code
970: , INV_PROJECT.GET_PROJECT_NUMBER project_number
971: , INV_PROJECT.GET_TASK_NUMBER task_number
972: , wlc.source_name
973: -- INVCONV start
974: , NVL(msiv.tracking_quantity_ind, 'P')
975: , nvl(wlc.secondary_quantity, 0)

Line 2031: INV_PROJECT.GET_LOCSEGS(moq.locator_id,

2027: moq.revision,
2028: msik.description,
2029: moq.subinventory_code,
2030: moq.locator_id,
2031: INV_PROJECT.GET_LOCSEGS(moq.locator_id,
2032: p_organization_id) concatenated_segments, --Physical Locator Segs
2033: moq.lot_number,
2034: msik.primary_uom_code,
2035: sum(nvl(moq.primary_transaction_quantity, 0)),

Line 2058: INV_PROJECT.GET_PROJECT_NUMBER project_number, --Project #

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 #
2060: -- INVCONV start
2061: NVL(msik.tracking_quantity_ind, 'P'),
2062: sum(nvl(moq.secondary_transaction_quantity, 0)),

Line 2059: INV_PROJECT.GET_TASK_NUMBER task_number, --Task #

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 #
2060: -- INVCONV start
2061: NVL(msik.tracking_quantity_ind, 'P'),
2062: sum(nvl(moq.secondary_transaction_quantity, 0)),
2063: msik.secondary_uom_code

Line 2098: INV_PROJECT.GET_LOCSEGS(moq.locator_id,p_organization_id),

2094: decode(p_Locator_Id, NULL, nvl(moq.locator_id, 0), p_Locator_Id)
2095: GROUP BY moq.organization_id, moq.inventory_item_id,
2096: msik.concatenated_segments, moq.revision, msik.description,
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,

Line 2120: INV_PROJECT.GET_PROJECT_NUMBER,

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,
2122: -- INVCONV start
2123: NVL(msik.tracking_quantity_ind, 'P'),
2124: msik.secondary_uom_code;

Line 2121: INV_PROJECT.GET_TASK_NUMBER,

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,
2122: -- INVCONV start
2123: NVL(msik.tracking_quantity_ind, 'P'),
2124: msik.secondary_uom_code;
2125: -- INVCONV end

Line 2217: INV_PROJECT.GET_LOCSEGS(moq.locator_id,

2213: moq.subinventory_code subinventory_code,
2214: msub.status_id subinventory_status_id,
2215: mms1.status_code subinventory_status,
2216: moq.locator_id locator_id,
2217: INV_PROJECT.GET_LOCSEGS(moq.locator_id,
2218: p_organization_id) milk_concatenated_segments, --Physical Locator Segements
2219: milk.status_id locator_status_id,
2220: mms2.status_code locator_status,
2221: moq.cost_group_id cost_group_id,

Line 2236: INV_PROJECT.GET_PROJECT_NUMBER project_number,

2232: SUM(DECODE(moq.containerized_flag, 1, 0, moq.secondary_transaction_quantity)) sec_loose_quantity,
2233: -- End Bug : 4563072
2234: msik.lot_control_code lot_control_code,
2235: msik.serial_number_control_code serial_number_control_code,
2236: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2237: INV_PROJECT.GET_TASK_NUMBER task_number,
2238: -- INVCONV start
2239: NVL(msik.tracking_quantity_ind, 'P') tracking_quantity_ind,
2240: msik.secondary_uom_code secondary_uom_code

Line 2237: INV_PROJECT.GET_TASK_NUMBER task_number,

2233: -- End Bug : 4563072
2234: msik.lot_control_code lot_control_code,
2235: msik.serial_number_control_code serial_number_control_code,
2236: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2237: INV_PROJECT.GET_TASK_NUMBER task_number,
2238: -- INVCONV start
2239: NVL(msik.tracking_quantity_ind, 'P') tracking_quantity_ind,
2240: msik.secondary_uom_code secondary_uom_code
2241: -- INVCONV end

Line 2292: INV_PROJECT.GET_LOCSEGS(moq.locator_id,p_organization_id),

2288: moq.subinventory_code,
2289: msub.status_id,
2290: mms1.status_code,
2291: moq.locator_id,
2292: INV_PROJECT.GET_LOCSEGS(moq.locator_id,p_organization_id),
2293: milk.status_id,
2294: mms2.status_code,
2295: moq.cost_group_id,
2296: csg.cost_group,

Line 2303: INV_PROJECT.GET_PROJECT_NUMBER,

2299: mms3.status_code,
2300: msik.primary_uom_code,
2301: msik.lot_control_code,
2302: msik.serial_number_control_code,
2303: INV_PROJECT.GET_PROJECT_NUMBER,
2304: INV_PROJECT.GET_TASK_NUMBER,
2305: -- INVCONV start
2306: NVL(msik.tracking_quantity_ind, 'P'),
2307: msik.secondary_uom_code

Line 2304: INV_PROJECT.GET_TASK_NUMBER,

2300: msik.primary_uom_code,
2301: msik.lot_control_code,
2302: msik.serial_number_control_code,
2303: INV_PROJECT.GET_PROJECT_NUMBER,
2304: INV_PROJECT.GET_TASK_NUMBER,
2305: -- INVCONV start
2306: NVL(msik.tracking_quantity_ind, 'P'),
2307: msik.secondary_uom_code
2308: -- INVCONV end

Line 2345: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,

2341: msn.revision,
2342: msik.description,
2343: msn.current_subinventory_code,
2344: msn.current_locator_id,
2345: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,
2346: p_organization_id) concatenated_segments, --Locator Segments
2347: msn.lot_number,
2348: msn.serial_number,
2349: msik.primary_uom_code,

Line 2351: INV_PROJECT.GET_PROJECT_NUMBER project_number,

2347: msn.lot_number,
2348: msn.serial_number,
2349: msik.primary_uom_code,
2350: 1,
2351: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2352: INV_PROJECT.GET_TASK_NUMBER task_number,
2353: msik.serial_number_control_code serial_number_control_code
2354: FROM MTL_SERIAL_NUMBERS msn,
2355: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */

Line 2352: INV_PROJECT.GET_TASK_NUMBER task_number,

2348: msn.serial_number,
2349: msik.primary_uom_code,
2350: 1,
2351: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2352: INV_PROJECT.GET_TASK_NUMBER task_number,
2353: msik.serial_number_control_code serial_number_control_code
2354: FROM MTL_SERIAL_NUMBERS msn,
2355: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2356: MTL_ITEM_LOCATIONS milk

Line 2417: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,

2413: msn.current_subinventory_code,
2414: msub.status_id subinventory_status_id,
2415: mms1.status_code subinventory_status,
2416: msn.current_locator_id,
2417: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,
2418: p_organization_id) concatenated_segments, --Locator Segments
2419: milk.status_id locator_status_id,
2420: mms2.status_code locator_status,
2421: msn.cost_group_id,

Line 2431: INV_PROJECT.GET_PROJECT_NUMBER project_number,

2427: msn.status_id serial_status_id,
2428: mms4.status_code serial_status,
2429: msik.primary_uom_code,
2430: 1,
2431: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2432: INV_PROJECT.GET_TASK_NUMBER task_number,
2433: msik.serial_number_control_code serial_number_control_code,
2434: DECODE(msn.lpn_id,NULL,0,1) packed_qty,
2435: DECODE(msn.lpn_id,NULL,1,0) loose_qty

Line 2432: INV_PROJECT.GET_TASK_NUMBER task_number,

2428: mms4.status_code serial_status,
2429: msik.primary_uom_code,
2430: 1,
2431: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2432: INV_PROJECT.GET_TASK_NUMBER task_number,
2433: msik.serial_number_control_code serial_number_control_code,
2434: DECODE(msn.lpn_id,NULL,0,1) packed_qty,
2435: DECODE(msn.lpn_id,NULL,1,0) loose_qty
2436: -- INVCONV start

Line 2580: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,

2576: msn.revision,
2577: msik.description,
2578: msn.current_subinventory_code,
2579: msn.current_locator_id,
2580: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,
2581: p_organization_id) concatenated_segments, --Locator Segments
2582: msn.lot_number,
2583: msik.primary_uom_code,
2584: count(msn.serial_number) total_qty,

Line 2590: INV_PROJECT.GET_PROJECT_NUMBER project_number,

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
2592: FROM MTL_SERIAL_NUMBERS msn,
2593: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2594: MTL_ITEM_LOCATIONS milk,

Line 2591: INV_PROJECT.GET_TASK_NUMBER task_number

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
2592: FROM MTL_SERIAL_NUMBERS msn,
2593: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2594: MTL_ITEM_LOCATIONS milk,
2595: MTL_SECONDARY_INVENTORIES msub,

Line 2630: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,p_organization_id),

2626: msn.revision,
2627: msik.description,
2628: msn.current_subinventory_code,
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),

Line 2638: INV_PROJECT.GET_PROJECT_NUMBER,

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;
2640:
2641: x_status := 'C';
2642: x_message := 'Records found';

Line 2639: INV_PROJECT.GET_TASK_NUMBER;

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;
2640:
2641: x_status := 'C';
2642: x_message := 'Records found';
2643: EXCEPTION

Line 2697: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,

2693: msn.current_subinventory_code subinventory_code,
2694: msub.status_id subinventory_status_id,
2695: mms1.status_code subinventory_status,
2696: msn.current_locator_id locator_id,
2697: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,
2698: p_organization_id) milk_concatenated_segments, --Physical Locator Segements
2699: milk.status_id locator_status_id,
2700: mms2.status_code locator_status,
2701: msn.cost_group_id cost_group_id,

Line 2711: INV_PROJECT.GET_PROJECT_NUMBER project_number,

2707: count(msn.serial_number) total_qty,
2708: count(decode(msn.lpn_id, null,1)) loose_qty,
2709: msik.lot_control_code lot_control_code,
2710: msik.serial_number_control_code serial_number_control_code,
2711: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2712: INV_PROJECT.GET_TASK_NUMBER task_number
2713: FROM mtl_serial_numbers msn,
2714: mtl_system_items_vl msik, /* Bug 5581528 */
2715: mtl_item_locations milk,

Line 2712: INV_PROJECT.GET_TASK_NUMBER task_number

2708: count(decode(msn.lpn_id, null,1)) loose_qty,
2709: msik.lot_control_code lot_control_code,
2710: msik.serial_number_control_code serial_number_control_code,
2711: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2712: INV_PROJECT.GET_TASK_NUMBER task_number
2713: FROM mtl_serial_numbers msn,
2714: mtl_system_items_vl msik, /* Bug 5581528 */
2715: mtl_item_locations milk,
2716: mtl_secondary_inventories msub,

Line 2763: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,p_organization_id),

2759: msn.current_subinventory_code,
2760: msub.status_id,
2761: mms1.status_code,
2762: msn.current_locator_id,
2763: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,p_organization_id),
2764: milk.status_id,
2765: mms2.status_code,
2766: msn.cost_group_id,
2767: csg.cost_group,

Line 2774: INV_PROJECT.GET_PROJECT_NUMBER,

2770: mms3.status_code,
2771: msik.primary_uom_code,
2772: msik.lot_control_code,
2773: msik.serial_number_control_code,
2774: INV_PROJECT.GET_PROJECT_NUMBER,
2775: INV_PROJECT.GET_TASK_NUMBER) b;
2776:
2777: x_status := 'C';
2778: x_message := 'Records found';

Line 2775: INV_PROJECT.GET_TASK_NUMBER) b;

2771: msik.primary_uom_code,
2772: msik.lot_control_code,
2773: msik.serial_number_control_code,
2774: INV_PROJECT.GET_PROJECT_NUMBER,
2775: INV_PROJECT.GET_TASK_NUMBER) b;
2776:
2777: x_status := 'C';
2778: x_message := 'Records found';
2779: EXCEPTION

Line 2864: INV_PROJECT.GET_LOCSEGS(moq.locator_id,

2860: moq.subinventory_code subinventory_code,
2861: msub.status_id subinventory_status_id,
2862: mms1.status_code subinventory_status,
2863: moq.locator_id locator_id,
2864: INV_PROJECT.GET_LOCSEGS(moq.locator_id,
2865: p_organization_id) milk_concatenated_segments, --Physical Locator Segements
2866: milk.status_id locator_status_id,
2867: mms2.status_code locator_status,
2868: msik.primary_uom_code primary_uom_code,

Line 2904: INV_PROJECT.GET_LOCSEGS(moq.locator_id,p_organization_id),

2900: moq.subinventory_code,
2901: msub.status_id,
2902: mms1.status_code,
2903: moq.locator_id,
2904: INV_PROJECT.GET_LOCSEGS(moq.locator_id,p_organization_id),
2905: milk.status_id,
2906: mms2.status_code,
2907: msik.primary_uom_code,
2908: msik.lot_control_code,