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.AHL_RM_ROUTE_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 302: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

298: PROCEDURE validate_adt_item
299: (
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
303: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
304: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
305: )
306: IS

Line 303: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

299: (
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
303: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
304: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
305: )
306: IS
307:

Line 304: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE

300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_data OUT NOCOPY VARCHAR2,
302: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
303: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
304: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
305: )
306: IS
307:
308: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;

Line 308: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;

304: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
305: )
306: IS
307:
308: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
309: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
310: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
311:
312: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,

Line 309: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;

305: )
306: IS
307:
308: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
309: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
310: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
311:
312: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
313: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)

Line 310: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;

306: IS
307:
308: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
309: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
310: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
311:
312: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
313: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)
314: IS

Line 312: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,

308: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
309: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
310: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
311:
312: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
313: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)
314: IS
315: --AMSRINIV. Bug 4913429. Doing away with the use of 'upper' to tune below query.
316: SELECT

Line 313: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)

309: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
310: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
311:
312: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
313: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)
314: IS
315: --AMSRINIV. Bug 4913429. Doing away with the use of 'upper' to tune below query.
316: SELECT
317: mtl.INVENTORY_ITEM_ID ,

Line 332: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

328: /*
329: SELECT DISTINCT MI.inventory_item_id,
330: MI.organization_id,
331: NVL(MI.inventory_item_flag,'X')
332: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
333: WHERE MP.organization_id = MI.organization_id
334: AND MI.concatenated_segments = c_item_number
335: AND MI.organization_id = c_inventory_org_id
336: AND MI.enabled_flag = 'Y'

Line 346: MTL_SYSTEM_ITEMS_KFV MTL

342: mtl.INVENTORY_ITEM_ID ,
343: mtl.organization_id ,
344: NVL(mtl.inventory_item_flag,'X')
345: from
346: MTL_SYSTEM_ITEMS_KFV MTL
347: , fnd_lookup_values_vl IT
348: , MTL_PARAMETERS MP
349: where
350: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'

Line 362: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

358: and upper(mtl.concatenated_segments) like upper(c_item_number)
359: and mtl.organization_id = c_inventory_org_id
360: order by 1;
361: */
362: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
363: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
364: IS
365: SELECT
366: mtl.INVENTORY_ITEM_ID ,

Line 363: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )

359: and mtl.organization_id = c_inventory_org_id
360: order by 1;
361: */
362: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
363: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
364: IS
365: SELECT
366: mtl.INVENTORY_ITEM_ID ,
367: mtl.organization_id ,

Line 380: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

376: /*
377: SELECT DISTINCT MI.inventory_item_id,
378: MI.organization_id,
379: NVL(MI.inventory_item_flag,'X')
380: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
381: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
382: AND MP.organization_id = MI.organization_id
383: AND MI.inventory_item_id = c_inventory_item_id
384: AND MI.organization_id = c_inventory_org_id

Line 393: from MTL_SYSTEM_ITEMS_KFV MTL

389: SELECT DISTINCT
390: mtl.INVENTORY_ITEM_ID ,
391: mtl.organization_id ,
392: NVL(mtl.inventory_item_flag,'X')
393: from MTL_SYSTEM_ITEMS_KFV MTL
394: , MTL_PARAMETERS MP
395: , fnd_lookup_values_vl IT
396: where
397: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'

Line 505: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

501: PROCEDURE validate_item
502: (
503: x_return_status OUT NOCOPY VARCHAR2,
504: x_msg_data OUT NOCOPY VARCHAR2,
505: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
506: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
507: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
508: )
509: IS

Line 506: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

502: (
503: x_return_status OUT NOCOPY VARCHAR2,
504: x_msg_data OUT NOCOPY VARCHAR2,
505: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
506: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
507: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
508: )
509: IS
510:

Line 507: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE

503: x_return_status OUT NOCOPY VARCHAR2,
504: x_msg_data OUT NOCOPY VARCHAR2,
505: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
506: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
507: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
508: )
509: IS
510:
511: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;

Line 511: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;

507: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
508: )
509: IS
510:
511: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
512: --l_wip_supply_type MTL_SYSTEM_ITEMS.wip_supply_type%TYPE; --pdoki commented for Bug 8589785
513: l_stock_enabled_flag MTL_SYSTEM_ITEMS.stock_enabled_flag%TYPE;
514: l_mtl_txns_enabled_flag MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag%TYPE;
515: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;

Line 512: --l_wip_supply_type MTL_SYSTEM_ITEMS.wip_supply_type%TYPE; --pdoki commented for Bug 8589785

508: )
509: IS
510:
511: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
512: --l_wip_supply_type MTL_SYSTEM_ITEMS.wip_supply_type%TYPE; --pdoki commented for Bug 8589785
513: l_stock_enabled_flag MTL_SYSTEM_ITEMS.stock_enabled_flag%TYPE;
514: l_mtl_txns_enabled_flag MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag%TYPE;
515: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
516: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;

Line 513: l_stock_enabled_flag MTL_SYSTEM_ITEMS.stock_enabled_flag%TYPE;

509: IS
510:
511: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
512: --l_wip_supply_type MTL_SYSTEM_ITEMS.wip_supply_type%TYPE; --pdoki commented for Bug 8589785
513: l_stock_enabled_flag MTL_SYSTEM_ITEMS.stock_enabled_flag%TYPE;
514: l_mtl_txns_enabled_flag MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag%TYPE;
515: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
516: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
517:

Line 514: l_mtl_txns_enabled_flag MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag%TYPE;

510:
511: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
512: --l_wip_supply_type MTL_SYSTEM_ITEMS.wip_supply_type%TYPE; --pdoki commented for Bug 8589785
513: l_stock_enabled_flag MTL_SYSTEM_ITEMS.stock_enabled_flag%TYPE;
514: l_mtl_txns_enabled_flag MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag%TYPE;
515: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
516: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
517:
518: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,

Line 515: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;

511: l_inventory_item_flag MTL_SYSTEM_ITEMS.inventory_item_flag%TYPE;
512: --l_wip_supply_type MTL_SYSTEM_ITEMS.wip_supply_type%TYPE; --pdoki commented for Bug 8589785
513: l_stock_enabled_flag MTL_SYSTEM_ITEMS.stock_enabled_flag%TYPE;
514: l_mtl_txns_enabled_flag MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag%TYPE;
515: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
516: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
517:
518: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
519: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)

Line 516: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;

512: --l_wip_supply_type MTL_SYSTEM_ITEMS.wip_supply_type%TYPE; --pdoki commented for Bug 8589785
513: l_stock_enabled_flag MTL_SYSTEM_ITEMS.stock_enabled_flag%TYPE;
514: l_mtl_txns_enabled_flag MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag%TYPE;
515: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
516: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
517:
518: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
519: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)
520: IS

Line 518: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,

514: l_mtl_txns_enabled_flag MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag%TYPE;
515: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
516: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
517:
518: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
519: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)
520: IS
521: SELECT DISTINCT MTL.inventory_item_id,
522: MTL.organization_id,

Line 519: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)

515: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
516: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
517:
518: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE ,
519: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE)
520: IS
521: SELECT DISTINCT MTL.inventory_item_id,
522: MTL.organization_id,
523: MTL.inventory_item_flag,

Line 540: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

536: NVL(MI.inventory_item_flag,'X'),
537: NVL(MI.mtl_transactions_enabled_flag,'X'),
538: NVL(MI.stock_enabled_flag,'X'),
539: NVL(MI.wip_supply_type,0)
540: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
541: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
542: AND MP.master_organization_id = MI.organization_id
543: AND MI.concatenated_segments = c_item_number
544: --AND MI.organization_id = c_inventory_org_id

Line 569: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

565: and mtl.inventory_org_id = c_inventory_org_id
566: order by 1;
567: */
568: --
569: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
570: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
571: IS
572: SELECT DISTINCT MTL.inventory_item_id,
573: MTL.organization_id,

Line 570: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )

566: order by 1;
567: */
568: --
569: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
570: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
571: IS
572: SELECT DISTINCT MTL.inventory_item_id,
573: MTL.organization_id,
574: MTL.inventory_item_flag,

Line 591: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

587: NVL(MI.inventory_item_flag,'X'),
588: NVL(MI.mtl_transactions_enabled_flag,'X'),
589: NVL(MI.stock_enabled_flag,'X'),
590: NVL(MI.wip_supply_type,0)
591: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
592: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
593: AND MP.master_organization_id = MI.organization_id
594: AND MI.inventory_item_id = c_inventory_item_id
595: --AND MI.organization_id = c_inventory_org_id

Line 729: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

725: PROCEDURE validate_service_item
726: (
727: x_return_status OUT NOCOPY VARCHAR2,
728: x_msg_data OUT NOCOPY VARCHAR2,
729: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
730: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
731: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
732: )
733: IS

Line 730: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

726: (
727: x_return_status OUT NOCOPY VARCHAR2,
728: x_msg_data OUT NOCOPY VARCHAR2,
729: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
730: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
731: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
732: )
733: IS
734:

Line 731: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE

727: x_return_status OUT NOCOPY VARCHAR2,
728: x_msg_data OUT NOCOPY VARCHAR2,
729: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
730: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
731: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
732: )
733: IS
734:
735: l_outside_operation_flag MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;

Line 735: l_outside_operation_flag MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;

731: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
732: )
733: IS
734:
735: l_outside_operation_flag MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;
736: l_purchasing_enabled_flag MTL_SYSTEM_ITEMS.purchasing_enabled_flag%TYPE;
737: l_purchasing_item_flag MTL_SYSTEM_ITEMS.purchasing_item_flag%TYPE;
738: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
739: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;

Line 736: l_purchasing_enabled_flag MTL_SYSTEM_ITEMS.purchasing_enabled_flag%TYPE;

732: )
733: IS
734:
735: l_outside_operation_flag MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;
736: l_purchasing_enabled_flag MTL_SYSTEM_ITEMS.purchasing_enabled_flag%TYPE;
737: l_purchasing_item_flag MTL_SYSTEM_ITEMS.purchasing_item_flag%TYPE;
738: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
739: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
740:

Line 737: l_purchasing_item_flag MTL_SYSTEM_ITEMS.purchasing_item_flag%TYPE;

733: IS
734:
735: l_outside_operation_flag MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;
736: l_purchasing_enabled_flag MTL_SYSTEM_ITEMS.purchasing_enabled_flag%TYPE;
737: l_purchasing_item_flag MTL_SYSTEM_ITEMS.purchasing_item_flag%TYPE;
738: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
739: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
740:
741: -- STHILAK -changed for bug# 9503666 - begin

Line 738: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;

734:
735: l_outside_operation_flag MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;
736: l_purchasing_enabled_flag MTL_SYSTEM_ITEMS.purchasing_enabled_flag%TYPE;
737: l_purchasing_item_flag MTL_SYSTEM_ITEMS.purchasing_item_flag%TYPE;
738: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
739: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
740:
741: -- STHILAK -changed for bug# 9503666 - begin
742: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE )

Line 739: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;

735: l_outside_operation_flag MTL_SYSTEM_ITEMS.outside_operation_flag%TYPE;
736: l_purchasing_enabled_flag MTL_SYSTEM_ITEMS.purchasing_enabled_flag%TYPE;
737: l_purchasing_item_flag MTL_SYSTEM_ITEMS.purchasing_item_flag%TYPE;
738: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
739: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
740:
741: -- STHILAK -changed for bug# 9503666 - begin
742: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE )
743: IS

Line 742: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE )

738: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
739: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
740:
741: -- STHILAK -changed for bug# 9503666 - begin
742: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE )
743: IS
744: SELECT DISTINCT MI.inventory_item_id,
745: mast.organization_id,
746: MI.outside_operation_flag,

Line 749: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI,mtl_system_items_b mast

745: mast.organization_id,
746: MI.outside_operation_flag,
747: MI.purchasing_item_flag,
748: MI.purchasing_enabled_flag
749: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI,mtl_system_items_b mast
750: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
751: AND MP.organization_id = MI.organization_id
752: AND MP.master_organization_id = mast.organization_id
753: AND MI.concatenated_segments = c_item_number

Line 759: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

755: AND SYSDATE BETWEEN NVL( MI.start_date_active, SYSDATE )
756: AND NVL( MI.end_date_active, SYSDATE );
757: --changed for bug# 9503666 - end
758:
759: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
760: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
761: IS
762: SELECT DISTINCT MI.inventory_item_id,
763: MI.organization_id,

Line 760: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )

756: AND NVL( MI.end_date_active, SYSDATE );
757: --changed for bug# 9503666 - end
758:
759: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
760: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
761: IS
762: SELECT DISTINCT MI.inventory_item_id,
763: MI.organization_id,
764: MI.outside_operation_flag,

Line 767: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

763: MI.organization_id,
764: MI.outside_operation_flag,
765: MI.purchasing_item_flag,
766: MI.purchasing_enabled_flag
767: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
768: WHERE DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',MP.eam_enabled_flag )='Y'
769: AND MP.organization_id = MI.organization_id
770: AND MI.inventory_item_id = c_inventory_item_id
771: AND MI.organization_id = c_inventory_org_id

Line 879: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

875: PROCEDURE validate_effectivity_item
876: (
877: x_return_status OUT NOCOPY VARCHAR2,
878: x_msg_data OUT NOCOPY VARCHAR2,
879: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
880: p_org_code IN MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,
881: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
882: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
883: )

Line 881: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

877: x_return_status OUT NOCOPY VARCHAR2,
878: x_msg_data OUT NOCOPY VARCHAR2,
879: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
880: p_org_code IN MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,
881: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
882: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
883: )
884: IS
885:

Line 882: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE

878: x_msg_data OUT NOCOPY VARCHAR2,
879: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
880: p_org_code IN MTL_PARAMETERS.ORGANIZATION_CODE%TYPE,
881: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
882: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
883: )
884: IS
885:
886: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;

Line 886: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;

882: p_x_inventory_org_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.organization_id%TYPE
883: )
884: IS
885:
886: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;
887: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
888: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
889:
890: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

Line 887: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;

883: )
884: IS
885:
886: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;
887: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
888: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
889:
890: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
891: c_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE)

Line 888: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;

884: IS
885:
886: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;
887: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
888: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
889:
890: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
891: c_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE)
892: IS

Line 890: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,

886: l_comms_nl_trackable_flag MTL_SYSTEM_ITEMS.COMMS_NL_TRACKABLE_FLAG%TYPE;
887: l_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE;
888: l_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE;
889:
890: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
891: c_org_code MTL_PARAMETERS.ORGANIZATION_CODE%TYPE)
892: IS
893: SELECT
894: MTL.INVENTORY_ITEM_ID ,

Line 908: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

904: /*
905: SELECT DISTINCT MI.inventory_item_id,
906: MP.master_organization_id,
907: MI.comms_nl_trackable_flag
908: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
909: WHERE MP.master_organization_id = MI.organization_id
910: AND upper(MI.concatenated_segments) = upper(c_item_number)
911: AND MI.enabled_flag = 'Y'
912: AND upper(MP.ORGANIZATION_CODE)=upper(c_org_code)

Line 922: from MTL_SYSTEM_ITEMS_KFV MTL

918: SELECT DISTINCT
919: mtl.INVENTORY_ITEM_ID ,
920: mtl.organization_id ,
921: mtl.comms_nl_trackable_flag
922: from MTL_SYSTEM_ITEMS_KFV MTL
923: , MTL_PARAMETERS MP
924: , MTL_PARAMETERS MP1
925: , fnd_lookup_values_vl IT
926: where

Line 940: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

936: and upper(mp1.organization_code) like upper(c_org_code)
937: order by 1;
938: */
939:
940: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
941: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
942: IS
943: SELECT
944: mtl.INVENTORY_ITEM_ID ,

Line 941: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )

937: order by 1;
938: */
939:
940: CURSOR get_rec_from_id ( c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
941: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
942: IS
943: SELECT
944: mtl.INVENTORY_ITEM_ID ,
945: mtl.organization_id ,

Line 958: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI

954: /*
955: SELECT DISTINCT MI.inventory_item_id,
956: MP.master_organization_id,
957: MI.comms_nl_trackable_flag
958: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
959: WHERE MP.master_organization_id = MI.organization_id
960: AND MI.inventory_item_id = c_inventory_item_id
961: AND MI.organization_id = c_inventory_org_id
962: AND MI.enabled_flag = 'Y'

Line 971: from MTL_SYSTEM_ITEMS_KFV MTL

967: /*SELECT DISTINCT
968: mtl.INVENTORY_ITEM_ID ,
969: mtl.organization_id ,
970: mtl.comms_nl_trackable_flag
971: from MTL_SYSTEM_ITEMS_KFV MTL
972: , MTL_PARAMETERS MP
973: , fnd_lookup_values_vl IT
974: where
975: DECODE(AHL_UTIL_PKG.IS_PM_INSTALLED,'Y','Y',mp.eam_enabled_flag )='Y'

Line 2172: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

2168: (
2169: x_return_status OUT NOCOPY VARCHAR2,
2170: x_msg_data OUT NOCOPY VARCHAR2,
2171: p_item_group_id IN AHL_ITEM_GROUPS_VL.item_group_id%TYPE,
2172: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
2173: p_inventory_org_id IN MTL_SYSTEM_ITEMS.organization_id%TYPE,
2174: p_uom_code IN MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2175: )
2176: IS

Line 2173: p_inventory_org_id IN MTL_SYSTEM_ITEMS.organization_id%TYPE,

2169: x_return_status OUT NOCOPY VARCHAR2,
2170: x_msg_data OUT NOCOPY VARCHAR2,
2171: p_item_group_id IN AHL_ITEM_GROUPS_VL.item_group_id%TYPE,
2172: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
2173: p_inventory_org_id IN MTL_SYSTEM_ITEMS.organization_id%TYPE,
2174: p_uom_code IN MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2175: )
2176: IS
2177:

Line 2181: c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,

2177:
2178: l_dummy VARCHAR2(1);
2179:
2180: CURSOR get_uom_for_item ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE,
2181: c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
2182: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
2183: IS
2184: SELECT 'X'
2185: FROM AHL_ITEM_CLASS_UOM_V

Line 2182: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )

2178: l_dummy VARCHAR2(1);
2179:
2180: CURSOR get_uom_for_item ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE,
2181: c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
2182: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
2183: IS
2184: SELECT 'X'
2185: FROM AHL_ITEM_CLASS_UOM_V
2186: WHERE uom_code = c_uom_code

Line 4017: from mtl_system_items_kfv kfv,

4013: from (select kfv.inventory_item_id,
4014: mp.master_organization_id inventory_org_id,
4015: mp.organization_code,
4016: kfv.concatenated_segments
4017: from mtl_system_items_kfv kfv,
4018: mtl_parameters mp
4019: where kfv.organization_id = mp.organization_id
4020: and exists (select 'X'
4021: from mtl_parameters mp1