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 737: FROM mtl_system_items_b

733: lStmtNo := 110;
734:
735: SELECT primary_uom_code
736: INTO l_primary_uom_code
737: FROM mtl_system_items_b
738: WHERE inventory_item_id = p_item_id
739: AND organization_id = p_oem_organization_id;
740:
741: IF g_log_enabled AND

Line 979: FROM mtl_system_items_b

975: lStmtNo := 150;
976:
977: SELECT segment1
978: INTO l_sub_comp
979: FROM mtl_system_items_b
980: WHERE inventory_item_id = p_item_id
981: AND organization_id = p_tp_organization_id ;
982:
983: fnd_message.set_name('JMF','JMF_SHK_REP_SO_ERROR');