DBA Data[Home] [Help]

APPS.CSD_ESTIMATE_UTILS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 191: FROM mtl_system_items_b

187: WHERE inventory_item_id = p_item_id
188: AND organization_id = Cs_Std.get_item_valdn_orgzn_id
189: AND uom_type =
190: (SELECT allowed_units_lookup_code
191: FROM mtl_system_items_b
192: WHERE organization_id = Cs_Std.get_item_valdn_orgzn_id
193: AND inventory_item_id = p_item_id)
194: AND uom_code = p_uom_code;
195: l_tmp_count NUMBER;

Line 1003: FROM mtl_system_items_b

999:
1000: -- Cursor to get the billable_flag
1001: CURSOR CUR_BILLING_TYPE(p_item_id NUMBER) IS
1002: SELECT material_billable_flag
1003: FROM mtl_system_items_b
1004: WHERE inventory_item_id = p_item_id
1005: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
1006:
1007: -- Cursor to get the item cost for a material item

Line 1286: FROM mtl_system_items_b

1282: DECODE(serial_number_control_Code, 1, 'N', '6', 'N', 'Y') serial_control,
1283: comms_nl_trackable_Flag ib_control,
1284: primary_uom_code,
1285: material_billable_flag
1286: FROM mtl_system_items_b
1287: WHERE inventory_item_id = p_item_id
1288: AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
1289:
1290: