APPS.INV_SHORTCHECKEXEC_PVT dependencies on MTL_SYSTEM_ITEMS

Line 428: FROM mtl_system_items

424: --
425: CURSOR L_Item_crs ( p_organization_id IN NUMBER,
426: p_inventory_item_id IN NUMBER ) IS
427: SELECT DECODE(check_shortages_flag,'Y',1,'N',2,NULL)
428: FROM mtl_system_items
429: WHERE inventory_item_id = p_inventory_item_id
430: AND organization_id = p_organization_id;
431: --
432: BEGIN

Line 552: L_item_conc_segments mtl_system_items_kfv.concatenated_segments%TYPE;

548: L_api_version CONSTANT NUMBER := 1.0;
549: L_api_name CONSTANT VARCHAR2(30) := 'SendNotifications';
550: L_user_name VARCHAR2(100);
551: L_notification_id NUMBER;
552: L_item_conc_segments mtl_system_items_kfv.concatenated_segments%TYPE;
553: L_organization_code VARCHAR2(3);
554: L_msg_name VARCHAR2(30);
555: l_org_id NUMBER; -- MOAC parameter
556: l_ou_org_id NUMBER; --Bug#6509349

Line 561: FROM mtl_system_items_kfv

557:
558: --
559: CURSOR L_Item_crs IS
560: SELECT concatenated_segments
561: FROM mtl_system_items_kfv
562: WHERE inventory_item_id = p_inventory_item_id
563: AND organization_id = p_organization_id;
564: --
565: CURSOR L_Org_crs IS

Line 592: mtl_system_items MSI,

588: CURSOR L_ShortTemp_csr IS
589: -- WIP component planner
590: SELECT DISTINCT FU.user_name user_name
591: FROM mtl_planners MP,
592: mtl_system_items MSI,
593: fnd_user FU,
594: mtl_short_chk_temp MSCT
595: WHERE L_ShortParam_rec.wip_notif_comp_planner_flag = 1
596: AND MSCT.object_type IN (1,2)

Line 607: mtl_system_items MSI,

603: -- WIP assembly planner (discrete jobs)
604: UNION
605: SELECT DISTINCT FU.user_name
606: FROM mtl_planners MP,
607: mtl_system_items MSI,
608: wip_entities WE,
609: fnd_user FU,
610: mtl_short_chk_temp MSCT
611: WHERE L_ShortParam_rec.wip_notif_ass_planner_flag = 1

Line 624: mtl_system_items MSI,

620: -- WIP assembly planner (repetitive schedules)
621: UNION
622: SELECT DISTINCT FU.user_name
623: FROM mtl_planners MP,
624: mtl_system_items MSI,
625: wip_repetitive_schedules WRS,
626: wip_repetitive_items WRI,
627: fnd_user FU,
628: mtl_short_chk_temp MSCT

Line 644: FROM mtl_system_items MSI,

640: AND FU.employee_id = MP.employee_id
641: -- WIP component buyer
642: UNION
643: SELECT DISTINCT FU.user_name
644: FROM mtl_system_items MSI,
645: fnd_user FU,
646: mtl_short_chk_temp MSCT
647: WHERE L_ShortParam_rec.wip_notif_comp_buyer_flag = 1
648: AND MSCT.seq_num = p_seq_num

Line 681: mtl_system_items MSI,

677: -- OE item planner
678: UNION
679: SELECT DISTINCT FU.user_name user_name
680: FROM mtl_planners MP,
681: mtl_system_items MSI,
682: fnd_user FU,
683: mtl_short_chk_temp MSCT
684: WHERE L_ShortParam_rec.oe_notif_item_planner_flag = 1
685: AND MSCT.object_type = 4

Line 994: L_item_conc_segments mtl_system_items_kfv.concatenated_segments%TYPE;

990: p_inventory_item_id IN NUMBER,
991: p_organization_id IN NUMBER
992: )
993: IS
994: L_item_conc_segments mtl_system_items_kfv.concatenated_segments%TYPE;
995: BEGIN
996: BEGIN
997: SELECT concatenated_segments
998: INTO L_item_conc_segments

Line 999: FROM mtl_system_items_kfv

995: BEGIN
996: BEGIN
997: SELECT concatenated_segments
998: INTO L_item_conc_segments
999: FROM mtl_system_items_kfv
1000: WHERE organization_id = p_organization_id
1001: AND inventory_item_id = p_inventory_item_id;
1002: EXCEPTION
1003: WHEN OTHERS THEN