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.CTO_DEACTIVATE_CONFIG_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 123: cfg_item_id mtl_system_items_kfv.inventory_item_id%type,

119: *****************************************************************************/
120:
121: -- bugfix2308063
122: TYPE r_cfg_item_details IS RECORD(
123: cfg_item_id mtl_system_items_kfv.inventory_item_id%type,
124: cfg_item_name mtl_system_items_kfv.concatenated_segments%type,
125: cfg_orgn_id number,
126: cfg_orgn_code mtl_parameters.organization_code%type,--5291392
127: msg VARCHAR2(200)

Line 124: cfg_item_name mtl_system_items_kfv.concatenated_segments%type,

120:
121: -- bugfix2308063
122: TYPE r_cfg_item_details IS RECORD(
123: cfg_item_id mtl_system_items_kfv.inventory_item_id%type,
124: cfg_item_name mtl_system_items_kfv.concatenated_segments%type,
125: cfg_orgn_id number,
126: cfg_orgn_code mtl_parameters.organization_code%type,--5291392
127: msg VARCHAR2(200)
128: );

Line 334: l_prev_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;

330:
331: loop_counter NUMBER;
332: l_prev_item_id NUMBER;
333: l_prev_org_id NUMBER;
334: l_prev_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
335: l_index NUMBER;
336: l_del_status BOM_PARAMETERS.bom_delete_status_code%type;
337: l_selected_inv_item_id MTL_SYSTEM_ITEMS_KFV.inventory_item_id%type;
338:

Line 337: l_selected_inv_item_id MTL_SYSTEM_ITEMS_KFV.inventory_item_id%type;

333: l_prev_org_id NUMBER;
334: l_prev_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
335: l_index NUMBER;
336: l_del_status BOM_PARAMETERS.bom_delete_status_code%type;
337: l_selected_inv_item_id MTL_SYSTEM_ITEMS_KFV.inventory_item_id%type;
338:
339: --bugfix#2162892
340: l_selected_inv_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
341:

Line 340: l_selected_inv_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;

336: l_del_status BOM_PARAMETERS.bom_delete_status_code%type;
337: l_selected_inv_item_id MTL_SYSTEM_ITEMS_KFV.inventory_item_id%type;
338:
339: --bugfix#2162892
340: l_selected_inv_item_name MTL_SYSTEM_ITEMS_KFV.concatenated_segments%type;
341:
342: --flag to move to next step
343: l_next_step_flag VARCHAR2(1);
344:

Line 368: cfg_item_id mtl_system_items_kfv.inventory_item_id%type,

364: mpconfig_cv MpConfigCurTyp;
365: chconfig_cv ChConfigCurTyp;
366:
367: TYPE tmp_item_rec IS RECORD(
368: cfg_item_id mtl_system_items_kfv.inventory_item_id%type,
369: cfg_item_name mtl_system_items_kfv.concatenated_segments%type,
370: cfg_orgn_id number,
371: msg VARCHAR2(1)
372: );

Line 369: cfg_item_name mtl_system_items_kfv.concatenated_segments%type,

365: chconfig_cv ChConfigCurTyp;
366:
367: TYPE tmp_item_rec IS RECORD(
368: cfg_item_id mtl_system_items_kfv.inventory_item_id%type,
369: cfg_item_name mtl_system_items_kfv.concatenated_segments%type,
370: cfg_orgn_id number,
371: msg VARCHAR2(1)
372: );
373:

Line 521: from mtl_system_items_kfv msi,

517: select msi.inventory_item_id,
518: msi.concatenated_segments,
519: msi.organization_id,
520: decode(mp.organization_id, mp.master_organization_id, 2, 1) order_level
521: from mtl_system_items_kfv msi,
522: mtl_parameters mp
523: where msi.base_item_id is NOT NULL
524: and msi.inventory_item_status_code <> l_del_status
525: and msi.organization_id = mp.organization_id

Line 538: from mtl_system_items_kfv msi,

534: select msi.inventory_item_id,
535: msi.concatenated_segments,
536: msi.organization_id,
537: decode(mp.organization_id, mp.master_organization_id, 2, 1) order_level
538: from mtl_system_items_kfv msi,
539: mtl_parameters mp
540: where msi.inventory_item_status_code <> l_del_status
541: and msi.organization_id = mp.organization_id
542: and msi.inventory_item_id = l_Config_Id

Line 555: from mtl_system_items_kfv msi,

551: select msi.inventory_item_id,
552: msi.concatenated_segments,
553: msi.organization_id,
554: decode(mp.organization_id, mp.master_organization_id, 2, 1) order_level
555: from mtl_system_items_kfv msi,
556: mtl_parameters mp
557: where msi.base_item_id = l_Model_Id
558: and msi.inventory_item_status_code <> l_del_status
559: and msi.organization_id = mp.organization_id

Line 574: from mtl_system_items_kfv msi,

570: select msi.inventory_item_id,
571: msi.concatenated_segments,
572: msi.organization_id,
573: decode(mp.organization_id, mp.master_organization_id, 2, 1) order_level
574: from mtl_system_items_kfv msi,
575: mtl_parameters mp
576: where msi.base_item_id = l_Model_Id
577: and msi.inventory_item_status_code <> l_del_status
578: and msi.organization_id = mp.organization_id

Line 631: from mtl_system_items_kfv msi

627: --
628: OPEN chconfig_cv FOR
629: select inventory_item_id,
630: concatenated_segments
631: from mtl_system_items_kfv msi
632: where organization_id = l_org_id
633: and base_item_id is NOT NULL
634: and inventory_item_status_code <> l_del_status
635: and NOT EXISTS (

Line 647: from mtl_system_items_kfv

643:
644: OPEN chconfig_cv FOR
645: select inventory_item_id,
646: concatenated_segments
647: from mtl_system_items_kfv
648: where organization_id = l_org_id
649: and base_item_id is NOT NULL
650: and inventory_item_status_code <> l_del_status
651: ORDER BY inventory_item_id;

Line 706: from mtl_system_items_kfv

702:
703: OPEN chconfig_cv FOR
704: select inventory_item_id,
705: concatenated_segments
706: from mtl_system_items_kfv
707: where organization_id = l_org_id
708: and inventory_item_id = l_config_id
709: and inventory_item_status_code <> l_del_status
710: ORDER BY inventory_item_id;

Line 724: from mtl_system_items_kfv

720: WriteToLog('Match profile is ON. Checking item level match attribute...', 2 );
721:
722: select nvl(config_match,'Y'), concatenated_segments
723: into l_config_match, l_model_desc
724: from mtl_system_items_kfv
725: where inventory_item_id = l_Model_Id
726: and organization_id = l_org_id;
727:
728: if l_config_match = 'Y' or l_config_match = 'C' then

Line 748: from mtl_system_items_kfv

744:
745: OPEN chconfig_cv FOR
746: select inventory_item_id,
747: concatenated_segments
748: from mtl_system_items_kfv
749: where organization_id = l_org_id
750: and base_item_id = l_Model_Id
751: and inventory_item_status_code <> l_del_status
752: ORDER BY inventory_item_id;

Line 774: from mtl_system_items_kfv

770:
771: OPEN chconfig_cv FOR
772: select inventory_item_id,
773: concatenated_segments
774: from mtl_system_items_kfv
775: where organization_id = l_org_id
776: and base_item_id = l_Model_Id
777: and inventory_item_status_code <> l_del_status
778: and option_specific_sourced in (1,2)

Line 800: from mtl_system_items_kfv

796:
797: OPEN chconfig_cv FOR
798: select inventory_item_id,
799: concatenated_segments
800: from mtl_system_items_kfv
801: where organization_id = l_org_id
802: and base_item_id = l_Model_Id
803: and inventory_item_status_code <> l_del_status
804: and inventory_item_id in (