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: sum(mmtt.transaction_quantity), --11873015
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 521: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,

517: mp.organization_code ,
518: mmtt.revision,
519: mmtt.subinventory_code ,
520: mmtt.locator_id,
521: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,
522: to_char(NULL) ,
523: to_char(NULL) ,
524: mmtt.transaction_uom,
525: nvl(mmtt.cost_group_id, 0),

Line 535: INV_PROJECT.GET_PROJECT_NUMBER, --Project Number

531: to_char(NULL), --Lot Status
532: lpn.lpn_context,
533: to_char(NULL), --Dock Door segs
534: msiv.serial_number_control_code,
535: INV_PROJECT.GET_PROJECT_NUMBER, --Project Number
536: INV_PROJECT.GET_TASK_NUMBER, --Task Number
537: to_char(NULL), --Source Name
538: -- INVCONV start
539: NVL(msiv.tracking_quantity_ind, 'P'),

Line 536: INV_PROJECT.GET_TASK_NUMBER, --Task Number

532: lpn.lpn_context,
533: to_char(NULL), --Dock Door segs
534: msiv.serial_number_control_code,
535: INV_PROJECT.GET_PROJECT_NUMBER, --Project Number
536: INV_PROJECT.GET_TASK_NUMBER, --Task Number
537: to_char(NULL), --Source Name
538: -- INVCONV start
539: NVL(msiv.tracking_quantity_ind, 'P'),
540: msiv.secondary_uom_code,

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

557: mp.organization_code ,
558: mmtt.revision,
559: mmtt.subinventory_code ,
560: mmtt.locator_id,
561: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id, mlc.organization_id),
562: mtlt.lot_number,
563: to_char(NULL) serial_number,
564: sum(mtLt.transaction_quantity), --Get qty for each lot; 11873015
565: mmtt.transaction_uom,

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

630: mp.organization_code ,
631: mmtt.revision,
632: mmtt.subinventory_code ,
633: mmtt.locator_id,
634: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id, mlc.organization_id),
635: mtlt.lot_number,
636: to_char(NULL) ,
637: mmtt.transaction_uom,
638: nvl(mmtt.cost_group_id, 0),

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

666: wlc.inventory_item_id, msiv.concatenated_segments, msiv.description,
667: wlc.organization_id , mp.organization_code ,
668: wlc.revision,
669: lpn.subinventory_code ,
670: lpn.locator_id, INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_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 ,

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

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

Line 681: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_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),
682: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
683: wlc.source_name,
684: -- INVCONV start
685: NVL(msiv.tracking_quantity_ind, 'P'),

Line 682: INV_PROJECT.GET_TASK_NUMBER(mlc.task_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),
682: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
683: wlc.source_name,
684: -- INVCONV start
685: NVL(msiv.tracking_quantity_ind, 'P'),
686: msiv.secondary_uom_code,

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

736: 0, null, wlc.item_description,
737: wlc.organization_id , mp.organization_code ,
738: wlc.revision,
739: lpn.subinventory_code ,
740: lpn.locator_id, INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id, mlc.organization_id),
741: null, null,
742: wlc.quantity, wlc.uom_code,
743: nvl(wlc.cost_group_id, 0), ccg.cost_group,
744: lpn.outermost_lpn_id, lpn3.license_plate_number ,

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

743: nvl(wlc.cost_group_id, 0), ccg.cost_group,
744: lpn.outermost_lpn_id, lpn3.license_plate_number ,
745: null, null, null,
746: lpn.lpn_context,
747: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id),
748: 0,
749: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_id),
750: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
751: wlc.source_name,

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

745: null, null, null,
746: lpn.lpn_context,
747: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id),
748: 0,
749: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_id),
750: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
751: wlc.source_name,
752: -- INVCONV start
753: 'P',

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

746: lpn.lpn_context,
747: INV_PROJECT.GET_LOCSEGS(milk2.inventory_location_id, milk2.organization_id),
748: 0,
749: INV_PROJECT.GET_PROJECT_NUMBER(mlc.project_id),
750: INV_PROJECT.GET_TASK_NUMBER(mlc.task_id),
751: wlc.source_name,
752: -- INVCONV start
753: 'P',
754: NULL,

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

806: wwlc.organization_id , mp.organization_code ,
807: wwlc.revision,
808: lpn.subinventory_code ,
809: lpn.locator_id,
810: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,
811: wwlc.lot_number, wwlc.serial_number,
812: -- Release 12: change to sum of primary quantity
813: -- and select primary uom
814: -- sum(wlc.quantity), wlc.uom_code, /* 3372973 : Sum of quantity is taken as wlc is grouped */

Line 825: INV_PROJECT.GET_PROJECT_NUMBER, --project number

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
826: INV_PROJECT.GET_TASK_NUMBER, --task number
827: wwlc.source_name,
828: -- INVCONV start
829: NVL(msiv.tracking_quantity_ind, 'P'),

Line 826: INV_PROJECT.GET_TASK_NUMBER, --task number

822: lpn.lpn_context,
823: NULL, --dock door
824: msiv.serial_number_control_code,
825: INV_PROJECT.GET_PROJECT_NUMBER, --project number
826: INV_PROJECT.GET_TASK_NUMBER, --task number
827: wwlc.source_name,
828: -- INVCONV start
829: NVL(msiv.tracking_quantity_ind, 'P'),
830: msiv.secondary_uom_code,

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

911: wlc.organization_id , mp.organization_code ,
912: wlc.revision,
913: lpn.subinventory_code ,
914: lpn.locator_id,
915: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id,mlc.organization_id) ,
916: wlc.lot_number, wlc.serial_number,
917: --Release 12(K), group by primary UOM
918: --wlc.uom_code,
919: msiv.primary_uom_code,

Line 928: INV_PROJECT.GET_PROJECT_NUMBER, --project number

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
929: INV_PROJECT.GET_TASK_NUMBER, --task number
930: wlc.source_name,
931: -- INVCONV start
932: NVL(msiv.tracking_quantity_ind, 'P'),

Line 929: INV_PROJECT.GET_TASK_NUMBER, --task number

925: lpn.lpn_context,
926: NULL, --dock door
927: msiv.serial_number_control_code,
928: INV_PROJECT.GET_PROJECT_NUMBER, --project number
929: INV_PROJECT.GET_TASK_NUMBER, --task number
930: wlc.source_name,
931: -- INVCONV start
932: NVL(msiv.tracking_quantity_ind, 'P'),
933: msiv.secondary_uom_code

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

942: wlc.organization_id , mp.organization_code ,
943: wlc.revision,
944: lpn.subinventory_code ,
945: lpn.locator_id,
946: INV_PROJECT.GET_LOCSEGS(mlc.inventory_location_id, mlc.organization_id),
947: null, null,
948: wlc.quantity, wlc.uom_code,
949: nvl(wlc.cost_group_id, 0), ccg.cost_group,
950: lpn.outermost_lpn_id, lpn3.license_plate_number ,

Line 955: INV_PROJECT.GET_PROJECT_NUMBER, --project number

951: null, null, null,
952: lpn.lpn_context,
953: NULL, --dock door
954: 0,
955: INV_PROJECT.GET_PROJECT_NUMBER, --project number
956: INV_PROJECT.GET_TASK_NUMBER, --task number
957: wlc.source_name,
958: -- INVCONV start
959: 'P',

Line 956: INV_PROJECT.GET_TASK_NUMBER, --task number

952: lpn.lpn_context,
953: NULL, --dock door
954: 0,
955: INV_PROJECT.GET_PROJECT_NUMBER, --project number
956: INV_PROJECT.GET_TASK_NUMBER, --task number
957: wlc.source_name,
958: -- INVCONV start
959: 'P',
960: NULL,

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

1025: , wlc.revision
1026: , lpn.subinventory_code
1027: , lpn.locator_id
1028: --, mlc.concatenated_segments
1029: , INV_PROJECT.GET_LOCSEGS(lpn.locator_id, lpn.organization_id) concatenated_segments
1030: , wlc.lot_number
1031: , wlc.serial_number
1032: , wlc.quantity
1033: , wlc.uom_code

Line 1046: , INV_PROJECT.GET_PROJECT_NUMBER project_number

1042: , lpn.gross_weight_uom_code
1043: , lpn.content_volume
1044: , lpn.content_volume_uom_code
1045: , msiv.serial_number_control_code
1046: , INV_PROJECT.GET_PROJECT_NUMBER project_number
1047: , INV_PROJECT.GET_TASK_NUMBER task_number
1048: , wlc.source_name
1049: -- INVCONV start
1050: , NVL(msiv.tracking_quantity_ind, 'P')

Line 1047: , INV_PROJECT.GET_TASK_NUMBER task_number

1043: , lpn.content_volume
1044: , lpn.content_volume_uom_code
1045: , msiv.serial_number_control_code
1046: , INV_PROJECT.GET_PROJECT_NUMBER project_number
1047: , INV_PROJECT.GET_TASK_NUMBER task_number
1048: , wlc.source_name
1049: -- INVCONV start
1050: , NVL(msiv.tracking_quantity_ind, 'P')
1051: , nvl(wlc.secondary_quantity, 0)

Line 2107: INV_PROJECT.GET_LOCSEGS(moq.locator_id,

2103: moq.revision,
2104: msik.description,
2105: moq.subinventory_code,
2106: moq.locator_id,
2107: INV_PROJECT.GET_LOCSEGS(moq.locator_id,
2108: p_organization_id) concatenated_segments, --Physical Locator Segs
2109: moq.lot_number,
2110: msik.primary_uom_code,
2111: sum(nvl(moq.primary_transaction_quantity, 0)),

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

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

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

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 #
2136: -- INVCONV start
2137: NVL(msik.tracking_quantity_ind, 'P'),
2138: sum(nvl(moq.secondary_transaction_quantity, 0)),
2139: msik.secondary_uom_code

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

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

Line 2196: INV_PROJECT.GET_PROJECT_NUMBER,

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,
2198: -- INVCONV start
2199: NVL(msik.tracking_quantity_ind, 'P'),
2200: msik.secondary_uom_code;

Line 2197: INV_PROJECT.GET_TASK_NUMBER,

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,
2198: -- INVCONV start
2199: NVL(msik.tracking_quantity_ind, 'P'),
2200: msik.secondary_uom_code;
2201: -- INVCONV end

Line 2313: INV_PROJECT.GET_LOCSEGS(moq.locator_id,

2309: moq.subinventory_code subinventory_code,
2310: msub.status_id subinventory_status_id,
2311: mms1.status_code subinventory_status,
2312: moq.locator_id locator_id,
2313: INV_PROJECT.GET_LOCSEGS(moq.locator_id,
2314: p_organization_id) milk_concatenated_segments, --Physical Locator Segements
2315: milk.status_id locator_status_id,
2316: mms2.status_code locator_status,
2317: moq.cost_group_id cost_group_id,

Line 2332: INV_PROJECT.GET_PROJECT_NUMBER project_number,

2328: SUM(DECODE(moq.containerized_flag, 1, 0, moq.secondary_transaction_quantity)) sec_loose_quantity,
2329: -- End Bug : 4563072
2330: msik.lot_control_code lot_control_code,
2331: msik.serial_number_control_code serial_number_control_code,
2332: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2333: INV_PROJECT.GET_TASK_NUMBER task_number,
2334: -- INVCONV start
2335: NVL(msik.tracking_quantity_ind, 'P') tracking_quantity_ind,
2336: msik.secondary_uom_code secondary_uom_code

Line 2333: INV_PROJECT.GET_TASK_NUMBER task_number,

2329: -- End Bug : 4563072
2330: msik.lot_control_code lot_control_code,
2331: msik.serial_number_control_code serial_number_control_code,
2332: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2333: INV_PROJECT.GET_TASK_NUMBER task_number,
2334: -- INVCONV start
2335: NVL(msik.tracking_quantity_ind, 'P') tracking_quantity_ind,
2336: msik.secondary_uom_code secondary_uom_code
2337: -- INVCONV end

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

2384: moq.subinventory_code,
2385: msub.status_id,
2386: mms1.status_code,
2387: moq.locator_id,
2388: INV_PROJECT.GET_LOCSEGS(moq.locator_id,p_organization_id),
2389: milk.status_id,
2390: mms2.status_code,
2391: moq.cost_group_id,
2392: csg.cost_group,

Line 2399: INV_PROJECT.GET_PROJECT_NUMBER,

2395: mms3.status_code,
2396: msik.primary_uom_code,
2397: msik.lot_control_code,
2398: msik.serial_number_control_code,
2399: INV_PROJECT.GET_PROJECT_NUMBER,
2400: INV_PROJECT.GET_TASK_NUMBER,
2401: -- INVCONV start
2402: NVL(msik.tracking_quantity_ind, 'P'),
2403: msik.secondary_uom_code

Line 2400: INV_PROJECT.GET_TASK_NUMBER,

2396: msik.primary_uom_code,
2397: msik.lot_control_code,
2398: msik.serial_number_control_code,
2399: INV_PROJECT.GET_PROJECT_NUMBER,
2400: INV_PROJECT.GET_TASK_NUMBER,
2401: -- INVCONV start
2402: NVL(msik.tracking_quantity_ind, 'P'),
2403: msik.secondary_uom_code
2404: -- INVCONV end

Line 2441: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,

2437: msn.revision,
2438: msik.description,
2439: msn.current_subinventory_code,
2440: msn.current_locator_id,
2441: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,
2442: p_organization_id) concatenated_segments, --Locator Segments
2443: msn.lot_number,
2444: msn.serial_number,
2445: msik.primary_uom_code,

Line 2447: INV_PROJECT.GET_PROJECT_NUMBER project_number,

2443: msn.lot_number,
2444: msn.serial_number,
2445: msik.primary_uom_code,
2446: 1,
2447: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2448: INV_PROJECT.GET_TASK_NUMBER task_number,
2449: msik.serial_number_control_code serial_number_control_code
2450: FROM MTL_SERIAL_NUMBERS msn,
2451: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */

Line 2448: INV_PROJECT.GET_TASK_NUMBER task_number,

2444: msn.serial_number,
2445: msik.primary_uom_code,
2446: 1,
2447: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2448: INV_PROJECT.GET_TASK_NUMBER task_number,
2449: msik.serial_number_control_code serial_number_control_code
2450: FROM MTL_SERIAL_NUMBERS msn,
2451: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2452: MTL_ITEM_LOCATIONS milk

Line 2513: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,

2509: msn.current_subinventory_code,
2510: msub.status_id subinventory_status_id,
2511: mms1.status_code subinventory_status,
2512: msn.current_locator_id,
2513: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,
2514: p_organization_id) concatenated_segments, --Locator Segments
2515: milk.status_id locator_status_id,
2516: mms2.status_code locator_status,
2517: msn.cost_group_id,

Line 2527: INV_PROJECT.GET_PROJECT_NUMBER project_number,

2523: msn.status_id serial_status_id,
2524: mms4.status_code serial_status,
2525: msik.primary_uom_code,
2526: 1,
2527: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2528: INV_PROJECT.GET_TASK_NUMBER task_number,
2529: msik.serial_number_control_code serial_number_control_code,
2530: DECODE(msn.lpn_id,NULL,0,1) packed_qty,
2531: DECODE(msn.lpn_id,NULL,1,0) loose_qty

Line 2528: INV_PROJECT.GET_TASK_NUMBER task_number,

2524: mms4.status_code serial_status,
2525: msik.primary_uom_code,
2526: 1,
2527: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2528: INV_PROJECT.GET_TASK_NUMBER task_number,
2529: msik.serial_number_control_code serial_number_control_code,
2530: DECODE(msn.lpn_id,NULL,0,1) packed_qty,
2531: DECODE(msn.lpn_id,NULL,1,0) loose_qty
2532: -- INVCONV start

Line 2676: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,

2672: msn.revision,
2673: msik.description,
2674: msn.current_subinventory_code,
2675: msn.current_locator_id,
2676: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,
2677: p_organization_id) concatenated_segments, --Locator Segments
2678: msn.lot_number,
2679: msik.primary_uom_code,
2680: count(msn.serial_number) total_qty,

Line 2686: INV_PROJECT.GET_PROJECT_NUMBER project_number,

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
2688: FROM MTL_SERIAL_NUMBERS msn,
2689: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2690: MTL_ITEM_LOCATIONS milk,

Line 2687: INV_PROJECT.GET_TASK_NUMBER task_number

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
2688: FROM MTL_SERIAL_NUMBERS msn,
2689: MTL_SYSTEM_ITEMS_VL msik, /* Bug 5581528 */
2690: MTL_ITEM_LOCATIONS milk,
2691: MTL_SECONDARY_INVENTORIES msub,

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

2722: msn.revision,
2723: msik.description,
2724: msn.current_subinventory_code,
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),

Line 2734: INV_PROJECT.GET_PROJECT_NUMBER,

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;
2736:
2737: x_status := 'C';
2738: x_message := 'Records found';

Line 2735: INV_PROJECT.GET_TASK_NUMBER;

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;
2736:
2737: x_status := 'C';
2738: x_message := 'Records found';
2739: EXCEPTION

Line 2793: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,

2789: msn.current_subinventory_code subinventory_code,
2790: msub.status_id subinventory_status_id,
2791: mms1.status_code subinventory_status,
2792: msn.current_locator_id locator_id,
2793: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,
2794: p_organization_id) milk_concatenated_segments, --Physical Locator Segements
2795: milk.status_id locator_status_id,
2796: mms2.status_code locator_status,
2797: msn.cost_group_id cost_group_id,

Line 2807: INV_PROJECT.GET_PROJECT_NUMBER project_number,

2803: count(msn.serial_number) total_qty,
2804: count(decode(msn.lpn_id, null,1)) loose_qty,
2805: msik.lot_control_code lot_control_code,
2806: msik.serial_number_control_code serial_number_control_code,
2807: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2808: INV_PROJECT.GET_TASK_NUMBER task_number
2809: FROM mtl_serial_numbers msn,
2810: mtl_system_items_vl msik, /* Bug 5581528 */
2811: mtl_item_locations milk,

Line 2808: INV_PROJECT.GET_TASK_NUMBER task_number

2804: count(decode(msn.lpn_id, null,1)) loose_qty,
2805: msik.lot_control_code lot_control_code,
2806: msik.serial_number_control_code serial_number_control_code,
2807: INV_PROJECT.GET_PROJECT_NUMBER project_number,
2808: INV_PROJECT.GET_TASK_NUMBER task_number
2809: FROM mtl_serial_numbers msn,
2810: mtl_system_items_vl msik, /* Bug 5581528 */
2811: mtl_item_locations milk,
2812: mtl_secondary_inventories msub,

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

2855: msn.current_subinventory_code,
2856: msub.status_id,
2857: mms1.status_code,
2858: msn.current_locator_id,
2859: INV_PROJECT.GET_LOCSEGS(msn.current_locator_id,p_organization_id),
2860: milk.status_id,
2861: mms2.status_code,
2862: msn.cost_group_id,
2863: csg.cost_group,

Line 2870: INV_PROJECT.GET_PROJECT_NUMBER,

2866: mms3.status_code,
2867: msik.primary_uom_code,
2868: msik.lot_control_code,
2869: msik.serial_number_control_code,
2870: INV_PROJECT.GET_PROJECT_NUMBER,
2871: INV_PROJECT.GET_TASK_NUMBER) b;
2872:
2873: x_status := 'C';
2874: x_message := 'Records found';

Line 2871: INV_PROJECT.GET_TASK_NUMBER) b;

2867: msik.primary_uom_code,
2868: msik.lot_control_code,
2869: msik.serial_number_control_code,
2870: INV_PROJECT.GET_PROJECT_NUMBER,
2871: INV_PROJECT.GET_TASK_NUMBER) b;
2872:
2873: x_status := 'C';
2874: x_message := 'Records found';
2875: EXCEPTION

Line 2976: INV_PROJECT.GET_LOCSEGS(moq.locator_id,

2972: moq.subinventory_code subinventory_code,
2973: msub.status_id subinventory_status_id,
2974: mms1.status_code subinventory_status,
2975: moq.locator_id locator_id,
2976: INV_PROJECT.GET_LOCSEGS(moq.locator_id,
2977: p_organization_id) milk_concatenated_segments, --Physical Locator Segements
2978: milk.status_id locator_status_id,
2979: mms2.status_code locator_status,
2980: msik.primary_uom_code primary_uom_code,

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

3012: moq.subinventory_code,
3013: msub.status_id,
3014: mms1.status_code,
3015: moq.locator_id,
3016: INV_PROJECT.GET_LOCSEGS(moq.locator_id,p_organization_id),
3017: milk.status_id,
3018: mms2.status_code,
3019: msik.primary_uom_code,
3020: msik.lot_control_code,