DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on MTL_SERIAL_NUMBERS

Line 3034: l_serial_number mtl_serial_numbers.serial_number%TYPE;

3030: l_rule_input_rec CSD_RULES_ENGINE_PVT.CSD_RULE_INPUT_REC_TYPE;
3031: x_rule_id NUMBER;
3032: l_line_tbl oe_order_pub.line_tbl_type := oe_order_pub.g_miss_line_tbl;
3033: l_header_id NUMBER;
3034: l_serial_number mtl_serial_numbers.serial_number%TYPE;
3035: l_instance_id NUMBER;
3036: l_service_start_date DATE;
3037: l_service_period VARCHAR2(3);
3038: l_ship_inv_item_id NUMBER;

Line 3219: mtl_serial_numbers_temp msnt

3215: AND wdd.source_code = 'OE'
3216: UNION ALL
3217: SELECT msnt.fm_serial_number
3218: FROM wsh_delivery_details wdd,
3219: mtl_serial_numbers_temp msnt
3220: WHERE wdd.source_header_id = l_header_id
3221: AND wdd.source_line_id = p_order_line_id
3222: AND wdd.source_code = 'OE'
3223: AND wdd.transaction_temp_id = msnt.transaction_temp_id