APPS.INVPVHDR dependencies on MTL_SYSTEM_ITEMS_B

Line 402: l_start_auto_lot_num mtl_system_items_b.START_AUTO_LOT_NUMBER%TYPE;

398: l_dummy varchar2(50);
399: l_seg_size number := 0;
400: l_uppercase_flag varchar2(1) ;
401: l_msg_name VARCHAR2(1000) := NULL;
402: l_start_auto_lot_num mtl_system_items_b.START_AUTO_LOT_NUMBER%TYPE;
403:
404: --2967569 : Required Segments check
405: l_segment_required NUMBER(10):=0;
406: l_required_flag varchar2(1) := 'Y';

Line 1040: from MTL_SYSTEM_ITEMS_B

1036: END IF;
1037:
1038: select count(*)
1039: into ext_flag
1040: from MTL_SYSTEM_ITEMS_B
1041: where inventory_item_id = l_item_id
1042: and organization_id = cr.organization_id
1043: and cr.transaction_type = 'CREATE';
1044: IF l_inv_debug_level IN(101, 102) THEN

Line 2252: from mtl_system_items_b

2248: --
2249: begin
2250: select 'item_in_source_org'
2251: into l_dummy
2252: from mtl_system_items_b
2253: where inventory_item_id = l_item_id
2254: and organization_id = cr.source_organization_id;
2255:
2256: exception