APPS.CSP_MO_MTLTXNS_UTIL dependencies on CSP_PACKLIST_SERIAL_LOTS

Line 1697: FROM CSP_Packlist_Serial_Lots

1693: INVENTORY_ITEM_ID,
1694: QUANTITY,
1695: LOT_NUMBER,
1696: SERIAL_NUMBER
1697: FROM CSP_Packlist_Serial_Lots
1698: WHERE packlist_line_id = p_packlist_line_id
1699: AND organization_id = p_organization_id;
1700: l_packlist_sl_rec CSP_Pack_Serial_Lots_PVT.plsl_Rec_Type;
1701: l_serial_number VARCHAR2(30):= NULL;

Line 1947: -- This is an error. The csp_packlist_serial_lots table should not contain any error

1943: RAISE FND_API.G_EXC_ERROR;
1944: END IF;
1945: l_serial_lot_flag := fnd_api.g_true;
1946: ELSE
1947: -- This is an error. The csp_packlist_serial_lots table should not contain any error
1948: -- that has neither serial number nor lot number.
1949: l_serial_lot_flag := fnd_api.g_false;
1950: exit;
1951: END IF;