DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ONT_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 365: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;

361: l_project_id NUMBER;
362: l_task_id NUMBER;
363:
364: l_project_tbl l_project_Tabtype;
365: l_sub_comp MTL_SYSTEM_ITEMS_B.segment1%TYPE;
366: l_order_number PO_HEADERS_ALL.SEGMENT1%TYPE;
367: l_message VARCHAR(2000);
368: l_status_flag BOOLEAN;
369:

Line 697: FROM mtl_system_items_b

693: END IF;
694:
695: SELECT primary_uom_code
696: INTO l_primary_uom_code
697: FROM mtl_system_items_b
698: WHERE inventory_item_id = p_item_id
699: AND organization_id = p_oem_organization_id;
700:
701: IF g_log_enabled AND

Line 835: FROM mtl_system_items_b

831: AND poll.po_header_id = poh.po_header_id);
832:
833: SELECT segment1
834: INTO l_sub_comp
835: FROM mtl_system_items_b
836: WHERE inventory_item_id = p_item_id
837: AND organization_id = p_tp_organization_id ;
838:
839: fnd_message.set_name('JMF','JMF_SHK_REP_SO_ERROR');